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).
|