I have multiple tables of data on one laaaaarge spreadsheet.
For instance, from AM112:BV112 down, I have correlation data. In another cell I have a MIN and a MAX formula to return the particular values for each argument from AM to BV. What I ALSO want, however, is the HEADER associated with each value.
So: if AZ112 turns out to be the MIN value, then I want to return the AZ2 Header of "ENERGY". Same for the MAX value.
Now, once I get this sussed for the data in the AM:BV, columns, I need to do the same in BW:DF, DG:EP, and a few more.
What I have right now is =OFFSET(AM2,0,MATCH(HK112,AM112:BV112,0)) where HK112 is my MIN formula. But it's not working right. It returns me a value, but not the correct one.
Bookmarks