Probably it's not an acceptable solution, but may be, so let;s try: a more complicated formula in L15 (and similar in other cells) shall be used:
(or it's equivalent with INDEX and MATCH for compatibility with older versions of excel)
On the other hand, you have quite complicated formulas in column D. I think that for D5
and copy down would be fine. If you really expecte error you cen use:
Second option - store a table with the numbers as numbers in one range and in the other range use Xlookup to "translate it" to currently selected language. This way you will have easily visible and easy to input real values and the translation too.
Note that depending on your regional settings you may need to use comas not semicolons as argument separators in formulas
Bookmarks