+ Reply to Thread
Results 1 to 2 of 2

Find data in table but return HEADER

  1. #1
    Registered User
    Join Date
    11-05-2008
    Location
    Connecticut
    Posts
    1

    Find data in table but return HEADER

    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.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531
    not totally sure I follow but this:

    =OFFSET(AM2,0,MATCH(HK112,AM112:BV112,0)

    could be perhaps ?

    =INDEX(AM2:BV2,1,MATCH(HK112,AM112:BV112,0))

    try to avoid using OFFSET where possible as it's volatile and in big files will hurt performance in the long run.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1