Home |
Search |
Today's Posts |
#1
|
|||
|
|||
INDIRECT syntax?
I am trying to reference a cell in another sheet, with values from 2 cells.
I can reference a cell with just the row data from another cell. INDIRECT("SHEET1!A" & O4) But if I want to reference a cell using both row and column data from other cells? Something like this, but this doesn't work. INDIRECT("Sheet1!R4 & O4") I've tried messing with the symbols all over the place. I'm completely lost. On top of that what do all these symbols in Indirect mean. ! " & ' any help appreciated. |
#2
|
|||
|
|||
Try this sir:
Indirect("SHEET1!A")+indirect(O4) to get the idea. "stephen.reading100" wrote: I am trying to reference a cell in another sheet, with values from 2 cells. I can reference a cell with just the row data from another cell. INDIRECT("SHEET1!A" & O4) But if I want to reference a cell using both row and column data from other cells? Something like this, but this doesn't work. INDIRECT("Sheet1!R4 & O4") I've tried messing with the symbols all over the place. I'm completely lost. On top of that what do all these symbols in Indirect mean. ! " & ' any help appreciated. |
#3
|
|||
|
|||
General wrote...
Try this sir: Indirect("SHEET1!A")+indirect(O4) to get the idea. .... What idea do you believe the expression above would convey? How to live with error return values? Syntactically, SHEET1!A could *only* be a worksheet-level defined name, and, semantically, only one referring to a literal range. "stephen.reading100" wrote... .... I can reference a cell with just the row data from another cell. INDIRECT("SHEET1!A" & O4) But if I want to reference a cell using both row and column data from other cells? Something like this, but this doesn't work. INDIRECT("Sheet1!R4 & O4") .... OP should try =INDIRECT("Sheet1!"&R4&O4) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
indirect formula | Excel Worksheet Functions | |||
is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
Indirect another wookbook | Excel Worksheet Functions | |||
Vlookup Syntax Error | New Users to Excel | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions |