VLOOKUP dragging down

[Ozlem]

Hi

When I drag down the VLOOKUP formula, it automatically changes th
array of the formula. The formula is this:

=VLOOKUP(D147,RATES!J2:K217,2,FALSE)

I want RATES!J2 to be constant but it changes to J3, J4 etc... How ca
I turn J2 to constant?

Any help will be appreciated..

Thanks.

 

[nika]

Hi
$J$2
You can use F4 on your keyboard to assist you with thi

 

[Don Guillett]

Just change to RATES!$J$2:$K$217

 

[Guest]

Change it to:
RATES!$J$2:$K$217

tj