Offset VLookup

[jonathan9560]

I have an excel spread shee with tables and I need to find a value.

1 A B C D E
2 a
3
4 0 0 0 12


I need to Lookup up "a" and return "12" is this possible?
I was thinking a Vlookup with Offset but cannot get it to work.
Any help is greatly appreiciated.

 

[jonathan9560]

I think I figured it out.

"=OFFSET(INDEX(A:E,MATCH(H1,A:A,0),5),3,,,)"

 

[Domenic]

Or simply...

=INDEX(A:E,MATCH(H1,A:A,0)+3,5)

Hope this helps!