In the example shown, a formula is used to identify the name of the contractor with the lowest bid. The formula in F6 is: The result, 99500, is fed into the MATCH function as the lookup value: Match then returns the location of this value in the range, 4, which goes into INDEX as the row number along with B5:B9 as the array: The INDEX function then returns the value at that position: Cymbal.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.