using the INDIRECT function

[Guest]

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?

 

[smw226 via OfficeKB.com]

Hi,

=INDIRECT(Sheet2!B9,TRUE)

HTH

Simon

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.aspx/ms-excel/200611/1