using vlookup to find exact match

[Janice Lee via OfficeKB.com]

Hi,
I have two spreadsheets with same field called IDs.
I want to know whether the IDs in the ID column of the first sheet is in
the ID column of the second.
I want to create a new column on the first sheet to return Yes/No depending
on the result. I think I could use vlookup formula but have no idea how.
Can anyone help me?
Thank you!

 

[Trevor Shuttleworth]

Janice

One way:

=IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"no","yes")

and drag down. Assumes your ID column is column A on both sheets.

Regards

Trevor

 

[Alan Beban]

Hi,
I have two spreadsheets with same field called IDs.
I want to know whether the IDs in the ID column of the first sheet is in
the ID column of the second.
I want to create a new column on the first sheet to return Yes/No depending
on the result. I think I could use vlookup formula but have no idea how.
Can anyone help me?
Thank you!

Without a lookup formula

=IF(COUNTIF(Sheet2!A:A,A1)>0,"yes","no")

filled down as far as required.

Alan Beban

 

[Janice Lee via OfficeKB.com]

For the given formula,

=IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"no","yes")

What is "ISNA" and what does each value separated with comma represent?
Thanks in advance!