#VALUE error using ''imported'' data

Question

Hi,

I get an error when trying to calculate with a value obtained from an INDIRECT function.

First some background: I need the possibility of adding a sheet from which to automatically obtain a value, this value is always in the same location so I am using an INDIRECT function like this: =INDIRECT("'"&$AK$2&"'!$F$3571")

$AK$2 is the sheet name and $F$3571 the value I need. This function works and produces the correct value. However, the second I try to do anything with this value (add, subtract, anything) I get the #VALUE error. I went to the root of the problem and tried to calculate with the desired value in the respective sheet and I'm getting the same issue there.

I'm guessing excel doesn't recognize the initial value in any way, how can I fix this? I have tried N(), VALUE(), and changing formats but nothing works. I am working with data stored in .tc files, I get them into excel by simply dragging the file into excel and it shows all the data, could something be going wrong there?

Any help would be greatly appreciated!

Lex

Answer 1

Yeah that would get a #VALUE error as well, but I just realised that the values I'm importing are using dots as decimal separators, while my excel was set to commas. So I'm switching it to dots as we speak and that appears to be working.

Thanks for the time though!

Answer 2

How about

=1*INDIRECT("'"&$AK$2&"'!$F$3571")