Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a Value in First Column of Table with VLOOKUP? | Excel Discussion (Misc queries) | |||
Table array in VLOOKUP (EXcel 2003) | Excel Worksheet Functions | |||
Excel auto recalc is occuring with no change to data. Help! | Excel Discussion (Misc queries) | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) |