VLOOKUP Tutorial

Video Tutorial: https://www.youtube.com/watch?v=OrL0TVeToi8

VLOOKUP is a useful formula that every experienced Excel user should be familiar with. It is a simple but very effective formula. It is used to transfer data between to data-sets that have a common identifier.

Vlookup.jpg

VLOOKUP

There are four (4) steps to the VLOOKUP function, each separated by a comma.

1. Value: The common identifier that can be used to connect both data-sets.

2. Table: The table (or range) that contains the data you want to bring over.

3. Col_Index: Identifies which specific column from the table (or range) you want to bring over.

4. Range_Lookup: TRUE = Approximate Match, FALSE = Exact Match.

Vlookup & INDEX/MatchMario Salazarvlookup, index/match, excel, tutorial, data, datamighty