VLOOKUP problem
 

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

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

VLOOKUP problem
 

=if(isnumber(match(a1,b:b,0)),"Found","not Found")

If you could live with True or false, you could use:

=isnumber(match(a1,b:b:,0))




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

--

Dave Peterson