I'm having a problem with my formula.
Screenshot 2023-02-15 034600.png
I want to use Google Sheets to display transposed chords from its original key through Substitute and Index.
Screenshot 2023-02-15 034809.png
The Correct value should be:
Screenshot 2023-02-15 035503.png
But this is the value being flashed:
Screenshot 2023-02-15 035646.png
However whenever Sheets detected prior values, it overwrites the correct values. Is there anything I can do to fix this? I've tried it connecting through "&" but its not working as I want it to be.
This should be the value needs to be replaced for transposing.
Screenshot 2023-02-15 035055.png
Bookmarks