VLOOKUP problem

G

GKW in GA

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
 
T

Tom Hutchins

In C1: =IF(ISERROR(VLOOKUP(B1,A:A,1,FALSE)),"","FOUND")
and copy down column C.

Hope this helps,

Hutch
 
D

Dave Peterson

=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))
 
Top