Software >> Applications >> Microsoft Office >> Excel >> How to use vlookup function populate columns by looking up a reference (lookup) table in another worksheet of the same workbook
Fig. 1 The lookup table is in Sheet1
The range to use as lookup is $A:$C. $ is used to make the it an absolute reference (does not change when copying to other cells)
Fig 2 The table with columns to be populated is in another worksheet. Use 'worksheetname'! to prefix the range to refer to different sheet.
lookup_value : the cell reference of containing the value to use as the key for the lookup
table_array : the range of cells that form the lookup table, with the lookup value in the first column and starting from first row
col_index_num : the number of columns relative to the lookup column