Lookup

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

Guest

I'm looking for a function that will lookup a value and return the value of
the cell directly below the cell in which the looked up value is found. In
this example I need to find the value of the cell directly below Apples.

A
1 Apples
2 .99
3 Pears
4 1.39

Any Ideas?
 
One way ..

Assuming data running in A1 down,

In C1 is the input, eg: Apples

Then in D1:
=OFFSET(A1,MATCH(C1,A:A,0),)
will return the required result.
 
Back
Top