hello
looking for a formula that finds the "first occurence" based on the "smallest" or "min" number?
i have attached my workbook. i tried to use index match but that simply gives me the "first instance" of the center # rather than the smallest or min it first occured in.
pls help.
this is my formula that is not incorporating "small":
=INDEX($H$6:$I$15,MATCH(L6,$I$6:$I$15,0),1)
i even tried the below it is doesnt work:
=SMALL(INDEX($H$6:$I$15,MATCH(L6,$I$6:$I$15,0),1),1)
Bookmarks