COPYING A LOOKUP CELL

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

= cell above last entered data 9
LOOKUP iterations in VBA 2007 0
VBA to copy from one workbook into another 0
Can Excel do 'lookups' and show different data depending upon the cell with the focus? 4
Arrays and scattered cell values or another way? 16
lookup and return column number 2
tabulate output data from different combination of input. 0
Lookup cell, find Tab then copy/paste 6

Top