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!

--
Message posted via http://www.officekb.com