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 J1...
  • evans370's avatar
    Sep 22, 2020

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

Resources