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.

DOWNLOAD WORKBOOK

Vlookup_Different Sheets

HELPFUL RESOURCE:

MOTH-excel_expert470x63

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Sum the Last 7 Transactions with the Offset Functi... What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number of ro...
VLOOKUP Function: Introduction 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 column (to the right) in the table array.Formula breakdown:=VLOOKUP(lookup_value, table_array, col_index_num, )What it means:=VLOOKUP(thi...
Advanced SUMPRODUCT Function: Count You can use the SUMPRODUCT function to create advanced analysis of your data set.  For example, you can calculate the number of time a sales rep has made sales in a particular region.  Watch below to see how easy it is to create a count with this advanced SUMPRODUCT function....
Getting the length of text with Excel’s LEN ... What does it do?Gives you the number of characters of the textFormula breakdown:=LEN(text)What it means:=LEN(text that you want to get the number of characters)There are times when you need to get the number of characters within a cell in Excel.  Thank...