L
loscherland
I want to copy down this vlookup table:
=VLOOKUP(A2,Q2:R14,2,FALSE)
But the lookup range changes for each row i copy down
Eg.
B1; =VLOOKUP(A2,Q2:R14,2,FALSE)
B2; =VLOOKUP(A3,*Q3:R15*,2,FALSE)
B3; =VLOOKUP(A4,*Q4:R16*,2,FALSE)
How do i copy down the formula & keep the same lookup range
=VLOOKUP(A2,Q2:R14,2,FALSE)
But the lookup range changes for each row i copy down
Eg.
B1; =VLOOKUP(A2,Q2:R14,2,FALSE)
B2; =VLOOKUP(A3,*Q3:R15*,2,FALSE)
B3; =VLOOKUP(A4,*Q4:R16*,2,FALSE)
How do i copy down the formula & keep the same lookup range