| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing cell referance with value in INDIRECT-formula
Hi!
Can anyone please guide me on how to change part of cell reference in this formula: =INDIRECT("'[" & $A$19 & "]Sheet1'!$B$2") The formula is in Sheet2, and I would like to change the reference $B$2 with the value from cell H1 in sheet2. I have tried with =INDIRECT("'[" & $A$19 & "]Sheet1'!$B$(=INDIRECT( H1)"), but it gives error #REF. Any help would be appreciated. -- HebbeLille |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get currency format from souce cell(s) of a formula or referance | Excel Discussion (Misc queries) | |||
| how do i referance an adjacent cell from a search? | Excel Discussion (Misc queries) | |||
| Help with a formula. Lookup? referance? | Excel Worksheet Functions | |||
| Formula that referance a Cell | Excel Discussion (Misc queries) | |||
| Cell referance for formula | Excel Worksheet Functions | |||
Threaded Mode
