Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem using the INDIRECT function
I would like to use the INDIRECT function to look at a cell on a different
sheet to my formula. I can get this to work fine if I enter the following formula; =INDIRECT("'Reference Sheet'!D4") (as my second sheet is called Reference Sheet) However, to get the 'D4' part of the formula I am using the following formula; =("D"&(ROW(D3)+(MATCH(C13,'Reference Sheet'!D3:$D$55,0)))) So I put the formulae together to get; =INDIRECT("'Reference Sheet'!"D"&(ROW(D3)+(MATCH(C13,'Reference Sheet'!D3:$D$55,0)))") But this gives an error and highlights "D", so I removed the "" and then the #REF! error appeared. I have tried using brackets and inverted commas in different places but i can't seem to get the formula to work. Any suggestions would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem using the INDIRECT function
=INDIRECT("'Reference Sheet'!D"&(ROW(D3)+(MATCH(C13,'Reference
Sheet'!D3:$D$55,0)))) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "hot dogs" wrote in message ... I would like to use the INDIRECT function to look at a cell on a different sheet to my formula. I can get this to work fine if I enter the following formula; =INDIRECT("'Reference Sheet'!D4") (as my second sheet is called Reference Sheet) However, to get the 'D4' part of the formula I am using the following formula; =("D"&(ROW(D3)+(MATCH(C13,'Reference Sheet'!D3:$D$55,0)))) So I put the formulae together to get; =INDIRECT("'Reference Sheet'!"D"&(ROW(D3)+(MATCH(C13,'Reference Sheet'!D3:$D$55,0)))") But this gives an error and highlights "D", so I removed the "" and then the #REF! error appeared. I have tried using brackets and inverted commas in different places but i can't seem to get the formula to work. Any suggestions would be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem using the INDIRECT function
Excellent, Thanks very much Bob.
"Bob Phillips" wrote: =INDIRECT("'Reference Sheet'!D"&(ROW(D3)+(MATCH(C13,'Reference Sheet'!D3:$D$55,0)))) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "hot dogs" wrote in message ... I would like to use the INDIRECT function to look at a cell on a different sheet to my formula. I can get this to work fine if I enter the following formula; =INDIRECT("'Reference Sheet'!D4") (as my second sheet is called Reference Sheet) However, to get the 'D4' part of the formula I am using the following formula; =("D"&(ROW(D3)+(MATCH(C13,'Reference Sheet'!D3:$D$55,0)))) So I put the formulae together to get; =INDIRECT("'Reference Sheet'!"D"&(ROW(D3)+(MATCH(C13,'Reference Sheet'!D3:$D$55,0)))") But this gives an error and highlights "D", so I removed the "" and then the #REF! error appeared. I have tried using brackets and inverted commas in different places but i can't seem to get the formula to work. Any suggestions would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT function do not work when other file is closed | Excel Discussion (Misc queries) | |||
numerical integration | Excel Discussion (Misc queries) | |||
Function INDIRECT | Excel Worksheet Functions | |||
Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions |