Lookup a value from one column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=IF(ISNUMBER(MATCH(A1,Replacements!F4:F100,0)),"OK","Failed")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
=IF(ISERROR(VLOOKUP(A1,Replacements!$F$1:$F$227,1,0)),"OK","Failed"), if the
two worksheets are in the same workbook/file.
 
Sorry , make that
=IF(ISERROR(VLOOKUP(A1,Replacements!$F$4:$F$1000,1,0)),"OK","Failed"), and
obviusly copy down to A91
 
Back
Top