VLOOKUP dragging down
 

Hi

When I drag down the VLOOKUP formula, it automatically changes the
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 can
I turn J2 to constant?

Any help will be appreciated..

Thanks..


--
Ozlem
------------------------------------------------------------------------
Ozlem's Profile: http://www.excelforum.com/member.php...o&userid=16215
View this thread: http://www.excelforum.com/showthread...hreadid=276287

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


--
nika
------------------------------------------------------------------------
nika's Profile: http://www.excelforum.com/member.php...o&userid=15360
View this thread: http://www.excelforum.com/showthread...hreadid=276287

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

--
Don Guillett
SalesAid Software

"Ozlem" wrote in message
...

Hi

When I drag down the VLOOKUP formula, it automatically changes the
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 can
I turn J2 to constant?

Any help will be appreciated..

Thanks..


--
Ozlem
------------------------------------------------------------------------
Ozlem's Profile:
http://www.excelforum.com/member.php...o&userid=16215
View this thread: http://www.excelforum.com/showthread...hreadid=276287

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

tj

"Ozlem" wrote:


Hi

When I drag down the VLOOKUP formula, it automatically changes the
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 can
I turn J2 to constant?

Any help will be appreciated..

Thanks..


--
Ozlem
------------------------------------------------------------------------
Ozlem's Profile: http://www.excelforum.com/member.php...o&userid=16215
View this thread: http://www.excelforum.com/showthread...hreadid=276287