Forum Discussion
Solved
Phrases corresponding with code
Hi All, I Would like your help. When I select or type a Language (from tab ORIGINAL) in cell E2 (in Tab Hazard_Precautionary_Statements) I would like to have the phrase corresponding with th...
MathijsSerlie Like tis then? See attached.
By the way, any reason for saving the file as xls? That's an ancient file version.
MathijsSerlie I recall using not the most effective formulas as you were restricted to xls files. Now I see you have attached an xlsx file. Does that mean you have "upgraded" somehow?
Anyway, the formulas will work but you need to extend the named ranges ('phases', 'languages' and 'codes') in the Name Manager. At the time, the names point to ranges that end on row 6081. But since then you have added a few hundred rows.
Thanks for your reply Riny, much appriciated. I learned something new and adjusted it myself in Name Manager.
Yes I managed to safe it as a xlsx file.
Kind regards,
Mathijs