Indirect Formula to return Text from one sheet to cell in another sheet

I am a wee bit stuck...

I have used the following formula, to return the contents of cell AC4 (a number) in the sheet that is named "Surname, Initial" where G3 contains the Surname, and T3 contains the initial:

=INDIRECT("'"&$G$3&", "&$T$3&"'!ac4")

I have used the same formula to return the contents of cell AC3 (a date) in the same sheet to another cell.

But when I did the same to return the contents of cell E4 (a text string), it has returned "0".

I wanted it to return whatever is in that cell, in this instance "Catalogue Co-ordinator".

I have realised that it must have something to do with the fact that it is a text string rather than a number, but am now stuck.

What formula could I use to return the text that is in cell E3 using the Indirect function to go to the correct sheet?

Check for a simple mistake -- does the referenced worksheet really have text there? I just tried it and had no problem.

I could kick myself - I tested it using details from one sheet, and then was checking the cell content of a different sheet. The sheet with the details I was using had nothing in that cell!

Thank you for the simple reply that has saved me lots of trouble!

We've all been there. Glad you got it sorted out.