开发者

Tricky Excel Lookup

开发者 https://www.devze.com 2023-02-14 03:01 出处:网络
I have a table in Excel that looks like this: Column AColumn B Header Desc 1Value1 开发者_如何学JAVADesc 2Value2

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

精彩评论

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