close
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 12I need to Lookup up quot;aquot; and return quot;12quot; is this possible?
I was thinking a Vlookup with Offset but cannot get it to work.
Any help is greatly appreiciated.I think I figured it out.
quot;=OFFSET(INDEX(A:E,MATCH(H1,A:A,0),5),3,,,)quot;Or simply...
=INDEX(A:E,MATCH(H1,A:A,0) 3,5)
Hope this helps!
In article .comgt;,wrote:
gt; I think I figured it out.
gt;
gt; quot;=OFFSET(INDEX(A:E,MATCH(H1,A:A,0),5),3,,,)quot;
全站熱搜
留言列表
