Compare a List

  • Thread starter Thread starter David Barnhart
  • Start date Start date
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?
 
I use =match()

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

Will return True if there's a match.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Lookup function to cell containing multiple values 3
Multiple Criteria 11
CF on Consecutive cells 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Excel Comparing two columns 1
Question about SUMIFS(A:A,...) 3
compare two cells with non-numeric data 1

Back
Top