Compare Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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?
 
Back
Top