How do I copare two Excel spread sheets using the V-look up?

[Drew]

I'm trying to see if a certain number is in a different spread sheet.

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon