Hi!

It's not real clear what you're trying to do.

If column G contains all the number from column N, then why do you need to
"compare" columns and when a match is found......

Need more info.

Biff

"Tommy" wrote in message
...
Let's say I want to compare data thusly:

I have two columns of numbers, G and N. Column G has more numbers than
column N, and includes every number in column N.

In each cell in column O is a string associated with the number in column
N.
I want to comare a number in column N with all the numbers in column G and
when I find a match, copy the string in column O to the appropriate cell
in
column M. I want to repeat this process until all the strings in column O
have been matched to their numbers in column G.

Whew! So. How do I do this?

Thanks,

Tommy