Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why is the INDIRECT function volatile? | Excel Worksheet Functions | |||
consolidate data using 3d function AND indirect | Excel Worksheet Functions | |||
INDIRECT function inside AND function | Excel Worksheet Functions | |||
Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions |