Look up data on the next line

[Guest]

Hi, I've got the following information on a spreasheet:

A B C
1 Asia Measurement 0.64
2 Goal 2.0

The Cell A2 is blank. I can get Asia's C1 data (0.64) with a Vlookup, but I
also want to get Asia's C2 (2.0) data without having to type "Asia" on A2.

Is there a way to do that?

 

[Guest]

=OFFSET(A1,1,2)

 

[T. Valko]

Possibly:

=INDEX(C1:C100,MATCH("Asia",A1:A100,0)+1)