Dragging a Formula

  • Thread starter Thread starter Jerry Spivey
  • Start date Start date
J

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
 
Jerry Spivey said:
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
Click to expand...

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

HTH
 
Use

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

--

HTH

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