Thread
:
VLOOKUP dragging down
View Single Post
#
3
Don Guillett
Posts: n/a
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
Reply With Quote