3/26/2012 10:03:01 PM
Excel Tip: 2D Matrix Lookups
By Richard Rost
In this new 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.
Click here for the full Excel 2D Matrix Lookup tutorial.
Keywords: excel tips