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)
精彩评论