I have the following formula which currently allows me to overcome the maximum 7 if formula limitation, however I have it looking at text and I wish to use the formula to look up a numerical value.
Formula in cell AF10 is: If(AE10<>"",INDEX(R10:AD10,MATCH(AE10,R7:AD7,0)),"")
AE10 represents the minimum price in the range from R10:AD10 with R7:AD7 representing the name of the companies submitted price.
I am trying to get the name of the company that matches the cheapest price to come up in cell AF10, however all I get is #NA.
Appreciate any assistance
FBS
Bookmarks