VLOOKUP Copy/Paste Problem
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
|