If array statements

[harold12]

How can i type this out in Excel?
Ignore my errors, not really good in coding, i hope you guys get a general idea.

Please Login or Register  to view this content.

i need to get a formula for excel, this is what i need to get from my formula but so far i keep getting errors, i know somehow i need to use arrays and all but i'm not too sure, please advise.



Thank you so much

[Olly]

Try:

Please Login or Register  to view this content.

It should be obvious that this precise formula only works with the correct named ranges ("Name","Check").

Without those, use normal cell references, such as:

Please Login or Register  to view this content.

[harold12]

But i have a whole list of names, all jumbled up. For example,
Some names may exist in Sheet 1 and may not exist in sheet 2

Sheet 1
James
mary
Don
John

Sheet 2
Harold
James
Mary
Tim

I want it to search for James in sheet 1 and James in sheet 2 then check whether the check=1 followed by the X and blank.
I cannot match the cells one by one i have too many rows.

Thank you

[Olly]

Where are you putting the results? In a column next to the names? On which worksheet?

Where is the check value stored?

Your requirements are vague. Can you be specific, please? Attaching a sample workbook (with your desired outcome) would help.