80 seconds
ago: Please note that the webserver will soon get its weekly reboot at 4:00 am Eastern Time. You may continue to use the site as normal, but you will be logged off at that time. You should be able to log right back on immediately, however. If you are in the process of placing an order, please make sure to complete it as quickly as possible, or come back after the reboot. Thank you. Sorry for any inconvenience.
Dismiss
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.
