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
multi-value lookup.
When you're finished with this tutorial, here's another
FREE video tutorial on MATCH & INDEX.