Change value inside a table, vlookup doesn't recalc automatically
 

I created a workbook with a lookup table, and I refer to the table via
VLOOKUP. I have the calculation set on automatic. When I change a value
inside the lookup table, vlookup does not recalculate (the value in the cell
referencing the table with VLOOKUP does not change).

Change value inside a table, vlookup doesn't recalc automatically
 

Two suggestions...

Make sure your lookup table is sorted in ascending order.

Also, set the "range lookup" field in the vlookup statement to FALSE. That
will require the statement to return a value only on an exact match.

Regards...

"XLNuckleHed" wrote:

I created a workbook with a lookup table, and I refer to the table via
VLOOKUP. I have the calculation set on automatic. When I change a value
inside the lookup table, vlookup does not recalculate (the value in the cell
referencing the table with VLOOKUP does not change).