lookup, I think

  • Thread starter Thread starter Gretchen
  • Start date Start date
G

Gretchen

Hello,
I am kind of new to using the lookup functions and am
having trouble setting up my formula. Here is the set-
up: I have three colums of data
Column A has 5760 cells
Column B has 574
Column C has 574

I want excel to search for each element in column A for
it's match in B, and to report the adjacent data in C into
column D.

I can send a copy of the spreadsheet to anyone if they
would like to see the data. I appreciate the help!
Gretchen
 
Gretchen

Btw, if your data is sorted in ascending order, you can use:
=VLOOKUP(A1,B:C,2,FALSE)

Look in the Help for VLOOKUP for further info.

Andy.
 
Back
Top