Thread: VLOOKUP or Index + Match?

I have a requirement to extract some data which under normal circumstances
would be easily accomplished as the formula =VLOOKUP(C2,$R$12:$T$1010,3,0) would return the correct result if R12 contained 301 and T12 contained XYZ i.e. XYZ would be returned. However, I want to return the contents of cell T13 which is always 1 rows below the match in column R.

Any help is always appreciated!

try this,

=INDEX($T$12:$T$1010,MATCH(C2,$R$12:$R$1010,0)+1)