Re: Fill Series Across Multiple Workbooks

Hi

Do you mean something like
=VLOOKUP(A1,Sheet2!$A$!:$G$1000,2,0)
where you are wanting to increment the 2 in the above to take successive columns from the lookup table?

If so, replace the 2 with Column(), which will increment with the column number as you drag across.

In B1 =VLOOKUP(A1,Sheet2!$A$!:$G$1000,Column(),0) would be exactly the same as B is column 2.
You can always do + or - a number after the column() variable if required.

If it is not this, then please pot back with more information about what you are trying to achieve.

Regards

Roger Govier



DangerMouse wrote:

Thanks for the reply that wasnt exactly what i was looking for however.

I am looking to fill series from an external workbook.

Any ideas?

thanks




.