• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

return value of cell based on value of two other cells

C

ccarruth

Member
Basic need is to find the first occurrence of a value, in a range of cells. Then based on the position of that cell go to a corresponding cell, probably using some type of OFFSET function. Wkbk attached.

BTW - you guys are great!
 

Attachments

  • chandoo source min price.xlsx
    10.5 KB · Views: 6
Not 100% sure I understood correctly but the results do match.
In Cell L5,
=MIN(G5:J5)
And in Cell K5,
=INDEX(A5:D5,1,MATCH(L5,G5:J5,0))

And then copy down.
 
You must log in or register to reply here.
Back
Top