Forum Discussion
Fill in a cell based on an answer from another range
As a General Contractor I am reviewing subcontractors/pricing... I have a list of prices in Row1 and a list of Contractor Names in Row2 I have a separate tab showing lowest price per trade. I use '...
First I would observe that it is more conventional to enter lists down a column rather than across the sheet as you describe; no doubt you have your reasons.
Legacy versions
= INDEX(contractor, MATCH(MIN(price), price, 0))
Excel 365
= XLOOKUP(MIN(price), price, contractor)
Return multiple matches
= FILTER(contractor, price=MIN(price))
Return 'n' contractor names and prices in ascending order
= TAKE(SORT(contractorPrices, 1, 1, TRUE),, n)