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)



"Pinkykeiron" wrote in message
...
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(ISERROR(VLOOKUP(A1,Replacements!$F$1:$F$227,1, 0)),"OK","Failed"), if the
two worksheets are in the same workbook/file.

--
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

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