Please enable JavaScript to view the comments powered by Disqus.


VLOOKUP(...A4,LookupSht!A1:B8,2,0)

Using VLOOKUP() to get values from multiple sheets.

To get the values from multiple sheets 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

Syntax

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

Lets chat on this