Problem with Vlookup and Data Validation


B

Billy B

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

Advertisements

T

T. Valko

Make sure calculation is set to automatic.

Tools>Options>Calculation tab>Automatic>OK
 
T

Tom Hutchins

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
Hope this helps,

Hutch
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top