Typically it may be just the table_array that needs locking.The column index number, or col_index_num, is used by the VLOOKUP function to enter what information to return about a record.If your table contains duplicates then VLOOKUP will not be up to the task. Check out the Able Bits Duplicate Remover for a more complete tool for handling duplicates in your Excel tables. A Pivot Table has been used to enable a user to select a Fruit ID from the report filter and a list of all the orders appears.
As more rows are added to the table, the VLOOKUP may need to be updated to ensure that these extra rows are included.
A limitation of the VLOOKUP function is that it cannot look to its left.
It will look down the leftmost column of a table and return information from the right.
The last argument of the VLOOKUP function, known as range_lookup, asks if you would like an approximate or an exact match.
In most cases people are looking for a particular product, order, employee or customer and therefore require an exact match.