lookup, I think

[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

 

[Andy B]

Gretchen

You could use VLOOKUP in column D:
=VLOOKUP(A1,B:C,2,TRUE)

Andy.

 

[Andy B]

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.