Good Morning All,

Could someone help .

If I copy a Vlookup across a whole column in a worksheet the table array
variable adjusts accordly to where the cell is .

e.g Sheet1 has VLOOKUP(A2,Sheet2!A1:D50000,2,FALSE)

if I copy this down to the next cell below it will become

VLOOKUP(A3,Sheet2!A2:D50001,2,FALSE)

What I want to do is lock the Table array so it stays the same no matter
where I copy the vlookup to.

can anyone help

Thanks in advance

Jason Cutmore

try this

VLOOKUP($A$2,Sheet2!$A$1:$D$50000,2,FALSE)

the $ is used for fixing the cell reference

if you want to fix only one part, you can do that as well
$A2 or A$2

hth

Carlo

"Jai_Friday" wrote:

Good Morning All,

Could someone help .

If I copy a Vlookup across a whole column in a worksheet the table array
variable adjusts accordly to where the cell is .

e.g Sheet1 has VLOOKUP(A2,Sheet2!A1:D50000,2,FALSE)

if I copy this down to the next cell below it will become

VLOOKUP(A3,Sheet2!A2:D50001,2,FALSE)

What I want to do is lock the Table array so it stays the same no matter
where I copy the vlookup to.

can anyone help

Thanks in advance

Jason Cutmore

Cheers Carlo,

Done the job ;)



"Carlo" wrote:

try this

VLOOKUP($A$2,Sheet2!$A$1:$D$50000,2,FALSE)

the $ is used for fixing the cell reference

if you want to fix only one part, you can do that as well
$A2 or A$2

hth

Carlo

"Jai_Friday" wrote:

Good Morning All,

Could someone help .

If I copy a Vlookup across a whole column in a worksheet the table array
variable adjusts accordly to where the cell is .

e.g Sheet1 has VLOOKUP(A2,Sheet2!A1:D50000,2,FALSE)

if I copy this down to the next cell below it will become

VLOOKUP(A3,Sheet2!A2:D50001,2,FALSE)

What I want to do is lock the Table array so it stays the same no matter
where I copy the vlookup to.

can anyone help

Thanks in advance

Jason Cutmore