How do I reference one cell below a cell reference?

[DukeRollo]

Suppose I have three columns of data. Columns A, B, and C.

In cell E1, I am going to input a piece of data that appears in Column A.

In cell F1, I have a VLOOKUP formula. This formula finds info in Column A and and then presents the corresponding data from column C.

In cell F2 what I want is a formula that grabs whatever data is in the cell immediately below the result of the VLOOKUP.

So for example, if my columns look like...
A--------B---------C
Sally----Female---age 18
Jimmy--Male------age 19
Mark----Male------age 21
Becky---Female---age 22

And the VLOOKUP input was "Jimmy", then the result of the VLOOKUP would be "Age 19". How do I write a formula that would return the result "Age 21" in the cell below?

Yes. I know that's an odd example. But I can't share what it's actually for due to work privacy etc. Thank you for reading.

[Glenn Kennedy]

No-one wants to see your real data. However, it doesn't take long to mock something up. It's better if YOU do it, as then things can be in the right place:

=INDEX($B$2:$B$7,MATCH(E4,$A$2:$A$7,0)+1)

[Fluff13]

How about
=INDEX(C2:C100,MATCH(E1,A2:A100,0)+1)

[Norie]

Perhaps.

=INDEX(C:C, MATCH(F1, A:A,0)+1)