I'm preparing a spreadsheet for work, and I'm comparing three different prices:formula.png
Is there a formula, such as IFS, that I can use to make this easier on me? As you can see, I want the name (AirNav, WB, or P66) to show depending on what the lowest price is.
Thank you for the help!
Last edited by TexasAggie13; 08-09-2016 at 05:05 PM.
Try
Heading row 1, data rows 2 to 4
in D2 and copy down
=INDEX($A$1:$C$1,,MATCH(MIN($A2:$C2),$A2:$C2,0))
That worked! Thank you so much, you saved me so much typing!
Assuming your titles are in row 1, try this in D2 and copy down:
=INDEX($A$1:$C$1,MATCH(MIN(A2:C2),A2:C2,0))
Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks