I have a complicated formula which basically returns a text string that looks something like this:
Now I just want to actually calculate this value. I have tried
but that returns a #REF error, and I can't figure out why, since there are no errors in the string itself.
I was hoping someone here might have ideas?
If you are interested in the details of the formula that generates the string, here it is:
TEXT(INDEX('recode ranges'!$A:$BG,MATCH('reformat numerical'!$A2,'recode ranges'!$A:$A,0),MATCH('reformat numerical'!K$1,'recode ranges'!$1:$1,0)),"General")&'rules for num format'!A3)
where the INDEX function returns the value which would be 48000 in the string example given above at the top of this post, and where the 'rules for num format'!A3 contains the text "/1000".
Thanks in advance for any help!