Compare Data

[Guest]

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

 

[JE McGimpsey]

One way:

M1: =VLOOKUP(G1,N:O,2,FALSE)

copy down as far as needed.

 

[Guest]

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.

 

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