Two-way lookup with INDEX and MATCH approximate

Tip: Two-way lookup with INDEX and MATCH approximate

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.

Duration 
3:10
Author 

Related shortcuts

Leave a Reply

Your email address will not be published. Required fields are marked *