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