Vlookup Table Array Not Working. Syntax of vlookup function vlookup lookup value table array col index num range lookup the parameters of the vlookup function are. Now go to the main data workbook and select the table array.
If your lookup value is not in the first column of the array you will see the n a error. The n a error results because the lookup value kale appears in the second column produce of the table array argument a2 c10. One constraint of vlookup is that it can only look for values on the left most column in the table array.
As per rule lookup value must be in the first leftmost column of a table array argument of the vlookup function.
In this case excel is looking for it in column a not column b. In the following table we want to retrieve the number of units sold for kale. Vlookup cannot look to its left. It is recommended to use vlookup table array where tables are co related with each other in terms of data.
