mathing values

  • Thread starter Thread starter adam
  • Start date Start date
A

adam

How do I find if on cells value matches another cells in a range of cells.
For example I have data in column G from 2 to 65000 and H from 2 to 65000. I
want to go line by line in column G and see if that data shows up anywhere in
H2:H65000.
 
I would insert a blank column between these two columns, so we're now
checking column G cells against the entire column I.

In the new empty column H at H2, enter this formula and copy it down:

=ISNUMBER(MATCH(G2, I:I, 0))

Once copied down, you will have TRUE/FALSE answers, all the TRUE answers
mean the value in G is somewhere in column I.

Does that help?
 
One way...

Entered in, say, F2 and copied down:

=ISNUMBER(MATCH(G2,H$2:H$65000,0))

TRUE = there is a match
FALSE = no match
 
If there is a match, do you want to know where the matching value is in Col
H? Or do you want to know only that there is a match? Otto
 
Back
Top