Main Profile

At A Glance

Excel Matrix Lookup (2D Lookup, Multi Value VLOOKUP) with MATCH and INDEX

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.Learn more Excel at http://599cd.com/XLMATRIXLearn more about VLOOKUP, MATCH, and INDEX at http://599CD.com/XN2XH1
Length: 10:13

Contact

Questions about Excel Matrix Lookup (2D Lookup, Multi Value VLOOKUP) with MATCH and INDEX

Want more info about Excel Matrix Lookup (2D Lookup, Multi Value VLOOKUP) with MATCH and INDEX? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question