Forum Discussion
Solved
Nested IF function with multiple cells for comparison
Hi, I am trying to create a nested IF formula to compare a column of prices. I am supposed to have a cell display the name of a vendor with the lowest price. For example, A2 through A6 have a list...
Wesley,
there is no need for a nested IF() formula.
=INDEX(A2:A6,MATCH(MIN(B2:B6),B2:B6,0))
Wesley,
there is no need for a nested IF() formula.
=INDEX(A2:A6,MATCH(MIN(B2:B6),B2:B6,0))