Transforming a Complex Pricing List into a Quoting Tool in Excel

Note: The formula @6:25 should have been,
=IFERROR(INDEX($B$2:$B$2215,MATCH($E2,$D$2:$D$2215,0)),"")
In this video, we demonstrate how to create a search tool from a pricing list using Excel, and then transform it into a full blown web application that can be published and shared with others.
Full article,
Part 1: www.spreadsheet...
Part 2: www.spreadsheet...