VLOOKUP is one of Excel's most used functions.
It is limited, however, to using a single lookup criterion when trying to find information in a data table.
We can get around this limitation by using an array formula to create a lookup formula that allows multiple criteria to be used when finding the data we are after.
So instead of finding items by name only, using multiple lookup criteria would allow you, for example, to find those with a certain name that were purchased from a specific supplier, or are a certain color.
To find out more read the step by step tutorial on Lookup Formula with Multiple Criteria in Excel.
Related Tutorials
Comments
No comments yet. Leave a Comment