Two-way lookup with INDEX and MATCH approximate
In this video, we’ll look at how to build a two-way lookup with INDEX and MATCH, using an an approximate match.
Here we have a simple cost calculator, which looks up cost based on on a material’s width and height. The match needs to be approximate. For example, if the width is 250, and the height is 325, the correct result is $1,800.
If the width is 450, and the height stays at 325, the correct result is $3,600.
We can build a formula that does this lookup using INDEX and MATCH.