Forum Discussion

evans370's avatar
evans370
Copper Contributor
Sep 22, 2020
Solved

Need help with a formula

Hello,
I have a formula in a specific cell which I have created with the CONCATENATE function to define a location of interest. That formula concatenates J with the number 15 to return the result J15 as a text string.

 

Question: How can I use the concatenated text string result as the cell input argument for another formula in another location? I want to be able to go to another cell in my worksheet and type = and then click on the cell where I have the concatenated formula and have it use its result as the input argument. 

 

Thanks for the help.

  • Problem solved...I needed to use the INDIRECT function to use the result of one cell as the input argument for another formula.

1 Reply

  • evans370's avatar
    evans370
    Copper Contributor

    Problem solved...I needed to use the INDIRECT function to use the result of one cell as the input argument for another formula.

Resources