Lookup
 

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?

Lookup
 

Try this:

C1 = lookup_value

=IF(C1="","",INDEX(A1:A10,MATCH(C1,A1:A10,0)+1))

--
Biff
Microsoft Excel MVP


"Zaphod117" wrote in message
...
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?

Lookup
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Zaphod117" wrote:
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?