Vlookup: Vertical Lookup in Excel

VLOOKUP: Vertical Lookup in Excel

Five things you were afraid to know. In Excel, VLOOKUP is probably more feared than Pivot Tables. While the name stands for “Vertical Lookup”, VLOOKUP is most used to merge data from another Excel sheet (or tab) to the one you are currently working.

For example, inventory descriptions may be in one Excel sheet and you need to place them in a column next to the inventory number in the current Excel sheet. Using sales representative details, this article will discuss the ins and outs of using VLOOKUP by way of five helpful tips.