Forum Discussion
evans370
Sep 22, 2020Copper Contributor
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...
- 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.
evans370
Sep 22, 2020Copper Contributor
Problem solved...I needed to use the INDIRECT function to use the result of one cell as the input argument for another formula.