VLOOKUP problem
In C1: =IF(ISERROR(VLOOKUP(B1,A:A,1,FALSE)),"","FOUND")
and copy down column C.
Hope this helps,
Hutch
"GKW in GA" wrote:
I have a .xls file in which column A and column B are formatted identically,
All entries that are in coumn B are in column A but there are entries in col
A that are not are in col B, i.e. col B is a subset of col A. For every entry
in column A that exists in col B, I want to place "found" in col C of the
same row as A. How can I do this with VLOOKUP
|