VLOOKUP is one of Excel's most used functions.
It is limited, however, to returning a single field of data from a data table.
We can get around this limitation by combining it with the COLUMN function to create a lookup formula that will return multiple fields or entire records if desired.
So instead of finding only the price of an item, you can also find the part number, the supplier, and any other information with one formula.
To find out more read the step by step tutorial on Find Multiple Fields of Data with Excel VLOOKUP.
Related Tutorials
Comments
No comments yet. Leave a Comment