Compare a List

D

David Barnhart

to compare a list of names or numbers... I would always seem to use two
VLOOKUP formulas...

i.e.. find A1 in B:B and find B1 in A:A

does anyone know a better way?
 
D

Dave Peterson

I use =match()

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

Will return True if there's a match.
 
Top