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?