What does it do?

Searches for a value in the first column of a table array and returns a value in the same row from another sheet´s column (to the right) in the table array.

Formula breakdown:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

What it means:

=VLOOKUP(this value in Sheet1, in this list in Sheet2, and get me value in this column in Sheet2, Exact Match/FALSE/0])

Sometimes you are faced with a situation where you have a list of data and you want to bring in complimentary data from a different sheet within the same workbook.

Let’s say that you have a list of “items” in a table within Sheet1 and you want to bring  in their corresponding “item id’s” from Sheet2.

You can manually copy and paste the item id’s from Sheet2 to Sheet1 but that would take too long and you are also prone to errors.

The quick and error-proof way is by using the VLOOKUP function.

See the tutorial below of how this can be achieved.


Vlookup_Different Sheets



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

INDIRECT Function in Excel What does it do? Returns a reference to a range. The referenced range can be a cell, a range of cells, or a named range. Formula breakdown: =INDIRECT(ref_text, ) What it means: =INDIRECT(Return the referenced range, Omit if the reference is an A1 style or enter FAL...
INDEX Function Introduction The INDEX function in Excel returns a cell´s values from within a table/array. It works like a map, so you have to select a range (table/array) and tell it to return you the coordinates (Row & Column numbers). So if you want to return values from a Price List or large d...
WEEKDAY function: Introduction The WEEKDAY function returns the day of the week corresponding to a date.  The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday). So if you want to find out on what day you were born, then the WEEKDAY function will remind you. DOWNLOAD WORKBOOK Help...
Advanced Sumproduct Function: Sum the Top 3 Sales ... This is probably the most advanced level a SUMPRODUCT function can reach and that is by including a nested array formula. In our example below we want to return the 3 Largest values from the North region and sum them up.  As we are asking our formula to perform multiple calcul...