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

[CJoQ]

Hi there,

I have written a simple vlookup formula, and I have tried to -drag- thi
formula down a to repeat itself on a number of rows - however, th
output for the very first cell that I am running this off is the same a
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 EXAMPL
*INPUT*
=VLOOKUP($D17,'MyGenericData Sheet'!$H$5:$BM$55,14,FALSE)

OUTPU
-Output 1- (this is desired).


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

INPU
=VLOOKUP($D1*8*,'MyGenericData Sheet'!$H$5:$BM$55,14,FALSE)

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

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


CJo

 

[Claus Busch]

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