Please enable JavaScript to view the comments powered by Disqus.


How to use VLOOKUP() to lookup value from another worksheet.

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. 

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


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

Lets chat on this