Compare Data

T

Tommy

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
 
T

Tommy

Almost there. Columns N and O are 80-some rows longer than columns A-M and
some data, especially in this area, is not being returned.
 
J

JE McGimpsey

Have no idea what you mean.

Did you copy the formula in M1 down as far as the data in column G goes?

If so, what do you expect to look up with blank cells?
 
Top