fill

  • Thread starter Thread starter monagan
  • Start date Start date
M

monagan

I have the lookup function:

=LOOKUP(A3,'Item Price List'!A2:A1726,'Item Price List'!D2:D1726)


which finds the value in A3 on another worksheet in column A an
returns the value in that row in column D.

I'm trying to fill down, but I only want the "A3" to increment itself
How do I stop the A2:a1726, and the d2:d1726 from incrementing also?

Monaga
 
$A$2:$A$1726
$D$2:$D$1726

And look up relative and absolute references in Help.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have the lookup function:

=LOOKUP(A3,'Item Price List'!A2:A1726,'Item Price List'!D2:D1726)


which finds the value in A3 on another worksheet in column A and
returns the value in that row in column D.

I'm trying to fill down, but I only want the "A3" to increment itself.
How do I stop the A2:a1726, and the d2:d1726 from incrementing also?

Monagan
 
Back
Top