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