To vlookup or not to vlookup?

**Redder Lurtz** · 11-19-2010, 05:15 AM

That is the question.

I have a list of towns, some of which are included in a survey. I need to identify which of the list of towns are included in that survey with a simple Y or N in the yellow colum in the attached example. Those towns in the survey are listed (number only) in the 'Included Towns' tab. I thought a vlookup would do this but I can't get any joy. Please help!

Many thanks.

**Rahul Nagar** · 11-19-2010, 05:27 AM

Hi,

Try this formula
=VLOOKUP(A5,'Included Towns'!A:A,1,0)

**som3body** · 11-19-2010, 05:29 AM

I am not a pro in excel but I have a solution that should do what you want.
Check the attached file.

**ratcat** · 11-19-2010, 05:35 AM

My two cents worth

Place in F1 and copy drag down

Please Login or Register  to view this content.

**Marcol** · 11-19-2010, 05:36 AM

Maybe this, or similar

=IF(ISERROR(VLOOKUP(A2,'Included Towns'!A:A,1,0)),"N","Y")

Hope this helps

**teylyn** · 11-19-2010, 05:36 AM

This formula in Data sheet, cell F2, copied down, does not require any helper column construct.

=IF(ISNA(MATCH(A2,'Included Towns'!A:A,0)),"N","Y")

see attached