Get cell value from another sheet (Indirect, left, find)

[cambone]

Trying to get a formula to retrieve data (The Time) from a cell on another sheet.

=IFERROR(INDIRECT(LEFT("'"&D8&"-TVDB'!"&"AB7"),FIND("M","'"&D8&"-TVDB'!"&"AB7",1)),"Unknown")

D8 is the sheet name with -TVDB tagged on the end
ex. The Simpsons-TVDB

On The Simpsons-TVDB sheet in AB7 cell is the value that is needed
ex. 8:00 PM on Sundays

I need the 8:00 PM from that cell

Thanks

 

[JonXL]

What problem are you having?

What's in the cells your formula references?

 

[cambone]

What problem are you having? It always returns Unknown

What's in the cells your formula references? Text (8:00 PM on Sundays)

 

[cambone]

Just wondering if I'm missing something in the formula for it not to get the text in the cell