Vlookup not updating automatically
The VLOOKUP below shows a table named Fruit List being used.Click on the references within the formula and press the .In this example both the lookup_value and table_array references were made absolute.These techniques will ensure that your VLOOKUP function will always be checking the entire table.
To format the range as a table, select the range of cells you want to use for the table_array and click Home Format as Table and select a style from the gallery.
If users will need to be able to do this, then it is not a viable solution.
Vlookup not updating automatically comments