Support Board
Date/Time: Fri, 07 Feb 2025 00:45:45 +0000
Post From: Spreadsheet programming question
| [2020-05-04 15:04:38] |
| User185210 - Posts: 66 |
|
Hello, I try to use indirect(concatenate but without success so far, this is what I did in cell bf1= id4.sg3@ bg1= 3 bf3=indirect((concatenate(($bf$1),value($bg$1)))) result is #REF! but the reference itself works! and if I replace id4.sg3@ by E, the formula works! and return E3 Is there a way to have that done with my reference including the "@"? thank you for your help |