Use CONCAT to create a formula

[Simon.xlsx]

Hi All,

Can't seem to find a solution for this problem

I have used CONCAT to create a formula,

Please Login or Register  to view this content.

This then returns ='EG-01'!E8

I copy the CONCAT cell and paste as plain text, my cell now shows ='EG-01'!E8

But excel will not execute this as a formula, and displays ='EG-01'!E8, instead of the value actually at that location

I simply want the cell to return the value in Sheet 'EG-01' E8

I have many cells, doing this task manually will take a very long time

This is probably an easy one for you Excel Guru's

Thanks in advance for any help

[XLent]

You can use INDIRECT,but note it is volatile ("I have many cells")

=INDIRECT("'"&A$1&"'!"&$C5)

[Simon.xlsx]

Hi Xlent

Thanks for this

This will work for the task needed