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