How to highlight approximate match lookups

Tip: How to highlight approximate match lookups

In this video, we’ll look at how to highlight approximate match lookups with conditional formatting.

Here we have a simple lookup table that shows material costs for various heights and widths. The formula in K8 uses the INDEX and MATCH functions to retrieve the correct cost based on width and height values entered in K6 and K7.

Note the that the lookup is based on an approximate match. Since values are in ascending order, MATCH checks the values until a larger value is reached, and then steps back and returns the previous position.

Duration 
3:55
Author 

Leave a Reply

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