Output value if another column meets a value



I am making a bid evaluation suite. It is made up of several separate sheets for each type of bid and those are supposed to feed to a main page that shows the lowest bid and that bidder only if it is a complete bid. Here is the basic set up:

So, the front page where all the lowest bids are shown should only return Vendor A since it is the lowest complete bid.

I have the "=SMALL({Range},1)" to show the lowest number and the "=INDEX({Range},MATCH(SMALL({Range},1),{Range},0))" functions working but I can't figure out the syntax to add in the condition that the "Complete Bid?" column be "Yes".


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!