drag of vlookup function does not work any more - arrg

U

Ulfert

guys, I hope someone can help me.

I have a makro that contains a vlookup and it worked perfectly up to now. But suddenly, the dragged cells do contain the value of the first cell.
When I go into the cell, open the function and close it again, the right value appears???

*???!!??
 
F

Frank Kabel

Hi
probably automatic calculation is disabled. Goto 'Tools - Options -
calculate' and enable it
 

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

Similar Threads

VLOOKUP & Data Validation 0
Vlookup and return sheet name also 2
Adding a VLookup to an AutoComplete ComboBox 0
VLOOKUP duplicate values in table the table array? Help me solve 1
Excel Countif Function - Calculating Between Two Sets of Values 3
Problem with Vlookup and Data Validation 3
Help with Vlookup 2
Vlookup problem 1

Top