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