Dragging vlookup formula not working

**gelandl** · 03-09-2010, 05:26 AM

Hi

I have a list of data and I am using a vlookup forlmula to auto populate 4 fields. However when I drag the formula down the sheet, it carries exactly the same data as for the first row. Even though it shows that the cell number has changed to the next row.

I have vlookup(G4,CALLDRIVER,13,FALSE) which works in row 4 - shows: 11:37am. When I drag the formula to row 5, the formula shows = vlookup(G5,CALLDRIVER,13, FALSE) But it shows the data from row 4 - shows 11:37.

Can anybody assist please?

**DonkeyOte** · 03-09-2010, 05:38 AM

Are you running in Auto Calcualtion mode ?

Originally Posted by Microsoft

How to change the mode of calculation in Excel 2007

Click the Microsoft Office Button, and then click Excel Options.
On the Formulas tab, select the calculation mode that you want to use.

How to change the mode of calculation in Excel 2003 and in earlier versions of Excel

Click Options on the Tools menu, and then click the Calculation tab.
Under Calculation, click the calculation mode that you want to use.

**gelandl** · 03-09-2010, 05:45 AM

Not sure what you mean by auto calculation mode?

**DonkeyOte** · 03-09-2010, 05:51 AM

Read the quote and follow directions as appropriate to your version.

for further info. on Calculation Modes see: http://www.decisionmodels.com/calcsecretse.htm

**gelandl** · 03-09-2010, 05:55 AM

Sorry for my silliness here, but I still dont see the relevance of auto calculation? I am drwaing data from a list on another sheet, but for some reason the first row of data appears in all the other rows when I drag even though the cell ref in the formula changes

**DonkeyOte** · 03-09-2010, 06:20 AM

"Dragging" a formula does not recalculate each of the newly created formulae unless you're running in Auto Calc mode (advised).

It might not be the reason for the results you're seeing but if as inferred you believe each new result should be different from the last then it is certainly the most obvious culprit
hence the request that you check that in the first instance

FWIW you can validate if this is the cause by pressing F9 and seeing if the results change.