reference a cell within a cell reference

[Paul Sheehan]

Hello All,
Can someone please tell me if it is possible to reference a cell within a cell reference. I have the following formula and would like to be able to reference a brand # (refer to the blue highlighted text) by placing the text "Brand '#02" into a cell and then reference ing this cell within the cell reference Table145613172123242829[@[Replaces OEM '#04, Brand '#02]]. I expect to be able to include the cell reference in a manner like shown in orange text below. this simple form obviously doesn't work. Is it possible to do this?

=IF(Table145613172123242829[@[Replaces OEM '#01, Brand '#02]=]=>0,CHAR(10)&"Replaces OEM: "&TEXTJOIN(", ",TRUE,Table145613172123242829[@[Replaces OEM '#01, Brand '#02]],Table145613172123242829[@[Replaces OEM '#02, Brand '#02]],Table145613172123242829[@[Replaces OEM '#03, Brand '#02]],Table145613172123242829[@[Replaces OEM '#04, B11]],Table145613172123242829[@[Replaces OEM '#05, Brand '#02]],Table145613172123242829[@[Replaces OEM '#06, Brand '#02]],Table145613172123242829[@[Replaces OEM '#07, Brand '#02]],Table145613172123242829[@[Replaces OEM '#08, Brand '#02]],Table145613172123242829[@[Replaces OEM '#09, Brand '#02]],Table145613172123242829[@[Replaces OEM '#10, Brand '#02]]),"")

 

[James006]

Hello,

To reference a cell's content, you can use the INDIRECT() function ...

HTH