Forum Discussion
Solved
Referencing Multiple Strings
Hi, I am looking to reference multiple cells, each with a different text string, and I want it to find the ultimate reference location and return the cell contents. For example - Cell A2 con...
=INDIRECT("'"&A2&A3&A4)This formula works in my sheet if the workbook from cell A2 is open.
=INDIRECT("'"&A2&A3&A4)This formula works in my sheet if the workbook from cell A2 is open.
Thank you! OliverScheurich That worked!
