Forum Discussion
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 the codes in collum A, in the language I selected/typed in cell E2 in row E. If a phrase is not available (not translated) in that particular language, the cell is empty.
I hope it all makes sense.
Kind regards,
Mathijs
MathijsSerlie Like tis then? See attached.
By the way, any reason for saving the file as xls? That's an ancient file version.
12 Replies
The key to making this sort of process reliable is to enforce absolute regularity in terms of the count of rows devoted to each language and their order. I normally wrap the data into a 2D grid so that each column corresponds to a language. It is still possible to work with one column by filtering the data FILTER and then using XLOOKUP
"Regular structure" = FILTER(phrase, language=langReq) "Data with missing rows" = LET( phraseLoc, FILTER(phrase, language=langReq), codeLoc, FILTER(code, language=langReq), XLOOKUP(codeReq, codeLoc, phraseLoc) )From there on, every irregularity you introduce broadly doubles to complexity of finding the data as well as the computational effort required to return it.
MathijsSerlie Perhaps you can rephrase your question with cell references and sheet names that correspond with the file you uploaded. Or upload another file.
