Show contents of cell, number of rows away from a specific cell

[bluecat2013]

Hi,

I am wanting to be able to specify a cell by typing in the contents and specify how many rows away and excel show me the contents of that cell.

So for example:

1. Oranges
2. Pears
3. Apples
4. Plums
5. Apricots
6. Dates
7. Lemons

----------------------

INPUT CELL FRUIT = Pears
INPUT CELL ROWS AWAY = 3

ANSWER CELL = Apricots

[Ace_XL]

With your data in Range A1:A7, B1 as Input cell fruit and C1 as Input cells rows away use

=index(A1:A7,MATCH(B1,A1:A7,0)+C1)

[bluecat2013]

Excellent! Thanks very much!