mathing values
 

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.

mathing values
 

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?
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"adam" wrote:

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.

mathing values
 

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

--
Biff
Microsoft Excel MVP


"adam" wrote in message
...
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.

mathing values
 

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

"adam" wrote in message
...
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.