using the INDIRECT function
 

I have been using the indirect function as shown below to give me the
contents of a cell. I have been setting up a formula to copy a list from one
position of a sheet to another, I have now sorted the formula I want so I
want to use the formula on the previous sheet to copy the list to that
position. However, this indirect function gives me the contents of (for
example) D4 on sheet 1 not D4 on sheet 2.

=(INDIRECT("D"&(ROW(D3)+(MATCH(D60,D3:$D$43,0)) - part of my formula

Does anybody know how to use the INDIRECT function to reference to another
sheet?

using the INDIRECT function
 

Hi,

=INDIRECT(Sheet2!B9,TRUE)

HTH

Simon

hot dogs wrote:
I have been using the indirect function as shown below to give me the
contents of a cell. I have been setting up a formula to copy a list from one
position of a sheet to another, I have now sorted the formula I want so I
want to use the formula on the previous sheet to copy the list to that
position. However, this indirect function gives me the contents of (for
example) D4 on sheet 1 not D4 on sheet 2.

=(INDIRECT("D"&(ROW(D3)+(MATCH(D60,D3:$D$43,0)) - part of my formula

Does anybody know how to use the INDIRECT function to reference to another
sheet?

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200611/1