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