Reverse Index Match Question

    Hello -


    I provided the current table structure I am trying to reference in Columns A-O, with the table I'm trying to build with a formula in Columns T-Y.


    In short, using the table structure established in Columns A-O, how to return the tag in Row #1, for the smallest number associated with each Name/Date. Any thoughts? Workbook is attached.

    Hello,


    In cell U3, you could test following formula

    Code
    =INDEX($A$1:$O$1,SUMPRODUCT(((INDIRECT("A"&MATCH($T3,$A$1:$A$6,0)&":"&"O"&MATCH($T3,$A$1:$A$6,0)))=MIN(INDIRECT(SUBSTITUTE(ADDRESS(1,MATCH(U$2,$A$2:$O$2,0),4),"1","")&MATCH($T3,$A$1:$A$6,0)&":"&SUBSTITUTE(ADDRESS(1,MATCH(U$2,$A$2:$O$2,0)+1,4),"1","")&MATCH($T3,$A$1:$A$6,0))))*COLUMN((INDIRECT("A"&MATCH($T3,$A$1:$A$6,0)&":"&"O"&MATCH($T3,$A$1:$A$6,0)))))-COLUMN((INDIRECT("A"&MATCH($T3,$A$1:$A$6,0)&":"&"O"&MATCH($T3,$A$1:$A$6,0))))+1)

    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Thanks for your thanks

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login