INDIRECT syntax?

[stephen.reading100]

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.

 

[Guest]

Try this sir:
Indirect("SHEET1!A")+indirect(O4)
to get the idea.

 

[Harlan Grove]

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... ....

....

OP should try

=INDIRECT("Sheet1!"&R4&O4)