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)
 
         
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论