开发者

Tricky Excel Lookup

I have a table in Excel that looks like this:

Column A    Column B   
Header
Desc 1     Value1    
开发者_如何学JAVADesc 2     Value2    
Total      TotalValue

I only know the Header name to search for but I want it return the TotalValue from Column B.

Any ideas on how to do this? Thanks!


 =OFFSET(A1;MATCH("Header";A1:A5;0)+2;1)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜