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.
=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.