Excel 2007 : lookup function

[aris_dxb]

I need help please.
I am storing thousands of serial number in one spreadsheet and named as " Serial Number Master File". In that file there are four colums that is Date, Model, Serial Number (S/N) and Status.

To avoid mistake in scanning the serial number, I need to scan in other spreadsheet named as "Scanning File". Can anyone create a formula wherin if a serial number is scanned, it will pop-up (Yes) if the serial number is available in "Serail Number Master File". If not, the formula will show error (No) if the serial number is not listed.

Thanks/Regards...

[NBVC]

e.g

=If(Isnumber(match(A1,'Serial Number Master File'!A:A,0)),"Yes","No")

This looks up the number in A1 of your "Scanning File" and finds it in column A of the Master File.. if found, "yes" is returned, otherwise a "no" is returned).