Table Array Lookup Vlookup. When i copy the formula the table array changes. Table array the range of cells in the source table containing the data we want to retrieve.
This will be the table array that we reference in our vlookup function. If they are not then you may have to put an if condition at col index num to get appropriate column. Lookup range the column range in the lookup sheets where to search for the lookup value.
Table array in vlookup function.
Choose the table array as a range of cells from a2 to d10 and make it absolute lock. Vlookup table array is used for finding and looking up the required values in the form of a table array. Now all we have to do is add our vlookup formula in column e. Open the vlookup function and choose lookup value as an employee name.
