2D Multi Value Lookups that you can't use VLOOKUP for
In this Microsoft Excel video tutorial, I'll show you how to
perform a LOOKUP that requires 2 values.
You can't perform a lookup like this with VLOOKUP alone. We'll use the MATCH
and INDEX functions to create a conversion table between grams,
kilograms, ounces, and pounds... but you can use this technique for ANY kind of
When you're finished with this tutorial, here's another
FREE video tutorial on MATCH & INDEX.