Forum Discussion
Entering Data Type from a cell reference
In your formula are semicolon, shouldn't there be a comma?
(= CONCAT (AH43; "/"; AH44))
At the same time, you should make sure that the cell formatting is not text (despite seeing numbers).
Here is a simple example of currency conversion using a formula.
Example in the inserted file.
Additional Information:
Hope I was able to help you with this info.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
I use a different language version of Excel (Polish) so in my case a semicolon is a proper sign to use in formulas.
Also I checked if the cell formating is text. It turned out to be not.
Now, I tried to use your approach using your Excel file with the Vlookup function. There is only one, strange problem. I created a separate file in which I began coppying your data just to check if I understand the whole mechanics behind the vlookup function. In a row of currency conversions I always get #REF! error despite having the same data, formula which you used. I attached the file with this issue.
Nevertheless, thanks very much for Your response.
I didn't look at your file, maybe I'll try again later when my antivirus protection is fully functional again. Here are all the cells with the formula again... maybe this will help you a bit for the time being.
If it still doesn't work the way you want it to, please let me know.
Thank you for your understanding and patience