VLOOKUP(...)
How to use VLOOKUP() to lookup value from another worksheet.
Used Functions
Category: Lookup and reference
Looks in the first column of an array and moves across the row to return the value of a cell
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Practice VLOOKUP Formula at Sheetzoom
VLOOKUP formula at Microsoft help
0
We need to refer to the table in the other sheet to fetch the value from it. The VLOOKUP() formula works by looking up the criteria in the first column of the table (the left most column) and returns the result from the provided column.