Quick Qtn on Vlookup - want the "Range" to be static when I copy ?!i

[Maverick27]

I want to replicate the VLOOKUP Function below to all rows in a Col. But i want the "ols!A1:FP1313" Range of the function to remain static throughout, but it is incrementing when i copy it ?

How can i get the Range to be Static when I copy it downwards ?

=VLOOKUP($A9,ols!A1:FP1313,65,FALSE)

Thanks.

 

[VoG]

Try

=VLOOKUP($A9,ols!A$1:FP$1313,65,FALSE)

 

[Maverick27]

Super. Thanks !!!