mathing values

[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.

 

[JBeaucaire]

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?

 

[T. Valko]

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

 

[Otto Moehrbach]

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