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 of vendor names, B2 through B6 have prices. I am supposed to use a nested IF function to make A9 show the name of the vendor with the lowest price. So far, I have come up with:
=if(B2<B3:B6,"Bobby's",if(B3<B2 ?????
How can I tell the cell to now compare B2 and B4 through B6?
Wesley,
there is no need for a nested IF() formula.
=INDEX(A2:A6,MATCH(MIN(B2:B6),B2:B6,0))
1 Reply
Wesley,
there is no need for a nested IF() formula.
=INDEX(A2:A6,MATCH(MIN(B2:B6),B2:B6,0))