Offset VLookup
 

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.

Offset VLookup
 

I think I figured it out.

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

Offset VLookup
 

Or simply...

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

Hope this helps!

In article .com,
wrote:

I think I figured it out.

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