Dragging a formula down isn't working - where am I going wrong?
 

Hi there,

I have written a simple vlookup formula, and I have tried to drag this formula down a to repeat itself on a number of rows - however, the output for the very first cell that I am running this off is the same as the last cell that I run it off and everywhere in between.

The simple VLOOKUP:
=VLOOKUP($D17,'MyGenericData Sheet'!$H$5:$BM$55,14,FALSE)


The Example
INPUT
=VLOOKUP($D17,'MyGenericData Sheet'!$H$5:$BM$55,14,FALSE)

OUTPUT
Output 1 (this is desired).


Great. However, I then drag the formula down one row, so:

INPUT
=VLOOKUP($D18,'MyGenericData Sheet'!$H$5:$BM$55,14,FALSE)

OUTPUT
Output 1 (same as Output 1, this is not desired).

This is driving me mad. How can this be? Please advise and many thanks in advance for your help.


CJoQ

I hit Ctrl + S and all formulas updated automatically, it is as if it needed a 'refresh' button. This thread can be closed. Thanks for your time.

Dragging a formula down isn't working - where am I going wrong?
 

Hi,

Am Mon, 17 Jun 2013 13:51:05 +0100 schrieb CJoQ:

I have written a simple vlookup formula, and I have tried to -drag- this
formula down a to repeat itself on a number of rows - however, the
output for the very first cell that I am running this off is the same as
the last cell that I run it off and everywhere in between.

you have switched the calculation to "Manuell"
Activate "Automatic"


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2