Sorry , make that
=IF(ISERROR(VLOOKUP(A1,Replacements!$F$4:$F$1000,1 ,0)),"OK","Failed"), and
obviusly copy down to A91

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Pinkykeiron" wrote:

Hi there,

I have a column A1:A91 that is full of serial numbers in a worksheet called
"Canadian Machine Watchlist" that i want to compare to another worksheets
serial numbers and return "Failed" or "OK". The second worksheet is called
"Replacements" and the range i want to look in is F4:F1000 to find matches to
the Canadian Machine Watchlist. I want to return the "Failed" if a match is
found and "OK" if no match is found, this should be listed in "Canadian
Machine Watchlist" column B.

Can anyone assist?

Thanks