Lookup

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top