COPYING A LOOKUP CELL

  • Thread starter Thread starter James
  • Start date Start date
J

James

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
 
Back
Top