|
COPYING A LOOKUP CELL
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 |
COPYING A LOOKUP CELL
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 |
| All times are GMT +1. The time now is 11:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com