Dragging a Formula

[Jerry Spivey]

Hi,

I have the following formula =VLOOKUP(A1,codes!A1:B33,2,FALSE). I need to
fill this formula for about 200 cells in column A. I need the first part of
the formula to update i.e., A2, A3 for each record while maintaining the
same lookup range (codes!A1:B33). When I drag the formula both arguments
increment. Is there a way to lock the look range in the formula from
updating when I apply this to the various cells in column A?

Thanks

Jerry

 

[Gordon]

Hi,

I have the following formula =VLOOKUP(A1,codes!A1:B33,2,FALSE). I need to
fill this formula for about 200 cells in column A. I need the first part
of the formula to update i.e., A2, A3 for each record while maintaining
the same lookup range (codes!A1:B33). When I drag the formula both
arguments increment. Is there a way to lock the look range in the formula
from updating when I apply this to the various cells in column A?

Thanks

Jerry

Highlight A1:B33 in the formula in the first cell and hit F4. That should
put $ signs in there. Then drag the formula.

HTH

 

[Bob Phillips]

Use

=VLOOKUP(A1,codes!$A$1:$B$33,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)