Hi,
I have a simple array of data consisting of several columns. Each column holds data for a specific date.
On a seperate worksheet I wish to display this data for each date and I am using lookup functions to get it. I am using the following formula:
VLOOKUP($A1,'Sheet2'!$A1:$AE273,3,0)
All I want to do is drag this formula across my cells so that the column reference number (3 in the example above) will increase by 1 for each column. No matter what I try the column ref will always remain fixed.
Can anyone help? It is driving me insane!
Many thanks,
Nibbles
I have a simple array of data consisting of several columns. Each column holds data for a specific date.
On a seperate worksheet I wish to display this data for each date and I am using lookup functions to get it. I am using the following formula:
VLOOKUP($A1,'Sheet2'!$A1:$AE273,3,0)
All I want to do is drag this formula across my cells so that the column reference number (3 in the example above) will increase by 1 for each column. No matter what I try the column ref will always remain fixed.
Can anyone help? It is driving me insane!
Many thanks,
Nibbles