View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
XLNuckleHed XLNuckleHed is offline
external usenet poster
 
Posts: 1
Default 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).