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.

Make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomaticOK

--
Biff
Microsoft Excel MVP


"Billy B" wrote in message
...
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.

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.

Tom, my automatic calculations are on. Any other thoughts?

"Tom Hutchins" wrote:

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.