CODEWITHSUNDEEP
excelexcel-formula
karansky
karansky

Reputation: 558

INDIRECT function referring to a cell with text does not work

I was looking at the official documentation of the INDIRECT function of Microsoft Excel here. I have successfully duplicated most of the examples there except the third one, which is =INDIRECT(A4) where cell A4 contains the word "George".

After inserting =INDIRECT(A4) into my own excel sheet, the only text I got is #REF!. Refer picture below:

enter image description here

How can I get the value "10" by inserting =INDIRECT(A4)?

Upvotes: 1

Views: 924

Answers (1)

Sebastian B
Sebastian B

Reputation: 451

If you want "George" to refer to Cell B4, you should insert it as a name that refers to B4

Upvotes: 1

Related Questions