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

And look up relative and absolute references in Help.

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

---
Message posted from http://www.ExcelForum.com/

Hi
try
=LOOKUP(A3,'Item Price List'!$A$42:$A$1726,'Item Price
List'!$D$2:$D$1726)

or use
=VLOOKUP(A3,'Item Price List'!$A$42:$D$1726,4,0)

take a look at
http://www.cpearson.com/excel/relative.htm

itself.