Please enable JavaScript to view the comments powered by Disqus.


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

Getting VLOOKUP() working with data table in a different sheet.  

To get the values from a different sheet, 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