I have a lookup cell that I need to copy over 3000 cells
in a workbook.

Is there anyway I can change the current code I'm puuting
in so that the lookup cell changes but NOT the array? At
the moment when I copy the cell down the array changes
along with the lookup.

=LOOKUP(A1,Suppliers!A2:B360)

The A1 part is the only section I want to change as I copy
it down.

Cheers

James

Try this James

=LOOKUP(A1,Suppliers!$A$2:$B$360)

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"James" wrote in message ...
I have a lookup cell that I need to copy over 3000 cells
in a workbook.

Is there anyway I can change the current code I'm puuting
in so that the lookup cell changes but NOT the array? At
the moment when I copy the cell down the array changes
along with the lookup.

=LOOKUP(A1,Suppliers!A2:B360)

The A1 part is the only section I want to change as I copy
it down.

Cheers

James