Copy down vlookup Formula

[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

 

[jammy]

Use =VLOOKUP(A2,$Q$2:$R$14,2,FALSE) for the range to stay the same

 

[loscherland]

Sound, new i was doin somethin stupid!

Thanks

 

[Frank Kabel]

Hi
try
=VLOOKUP(A2,$Q$2:$R$14,2,FALSE)
you may have a look at relative/absolute references in the Excel help
or have a look at:
http://www.cpearson.com/excel/relative.htm