Forum Discussion
ROW(), INDIRECT() & MID() functions - syntax and result (help)
Hello everybody! My name’s FC, I’m 36 and I’m from Italy. By "sifting" on-line I found solution to several of my questions, often just doing "copy & paste" and trying ... I wish I wouldn’t limit ...
Hi, i have a similar problem in my case i dont understand the indirect function too well.
If i put in
A1=T
B1=2
And the indirect function in the cell
C3 = Indirect(A1)
The result should be C3 = 2, but all i have is a error #Ref
And it says that the celd is not valid
If you could help it would be great.
Hi,
INDIRECT returns the reference specified in the text. If you take =INDIRECT("A1") that will be converted to =A1 and result is "T".
If =INDIRECT(A1) it takes the text from A1, converts to =T, that's wrong reference and result is #REF