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.
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.