Problem with Vlookup and Data Validation
Is your Calculation option set to Manual? Try pressing F9.
To set calculation to automatic: in XL2007, select Formulas Calculation
Options Automatic. In XL2003, select Tools Options Calculation tab
Automatic.
Hope this helps,
Hutch
"Billy B" wrote:
I have a cell with data validation. Cell D4 in the worksheet contains a
validation list that comes from a range named FullList and that works fine.
There are three cells which I have written VLookup formulas that get data
from the second, third and fourth columns of the FullList range. What I want
to do is have the 3 cells change based on the contents of D4. If I open the
workbook new, the Vlookup cells change based on my selection however, when I
make another selection in D4, the values do not change in the Vlookup cells.
I have tried RefreshAll without success. Is there another function to refresh
the data in the Vlookup cells?
Thank you very very much.
|