Hi everyone
I made a quick search but didn't find anything similar in the existing threads, so I am posting my question:
I have a sheet where the language can be chosen (German & French) as a dropdown list at the beginning (let's say in A1). In the 50 cells below (A2-A51) there is a second dropdown list with some products, whose names are in the selcted language. When the user selects a product, a corresponding value is returned to the cells B2-B51, based on a VLOOKUP command.
The problem is that if the user makes the product selection in a language (eg in A2) of the product AND THEN changes the language, the selection in A2 remains in the first chosen language and as a result the VLOOKUP command does not work (it is set to function based on the language selection). So the user must re-select all the products in the new language and since it can take some time, I would like to see if it could be avoided.
Is there a way/trick to solve this?
Thanks in advance, I tried to describe it as clear as possible, I hope I made it
I made a quick search but didn't find anything similar in the existing threads, so I am posting my question:
I have a sheet where the language can be chosen (German & French) as a dropdown list at the beginning (let's say in A1). In the 50 cells below (A2-A51) there is a second dropdown list with some products, whose names are in the selcted language. When the user selects a product, a corresponding value is returned to the cells B2-B51, based on a VLOOKUP command.
The problem is that if the user makes the product selection in a language (eg in A2) of the product AND THEN changes the language, the selection in A2 remains in the first chosen language and as a result the VLOOKUP command does not work (it is set to function based on the language selection). So the user must re-select all the products in the new language and since it can take some time, I would like to see if it could be avoided.
Is there a way/trick to solve this?
Thanks in advance, I tried to describe it as clear as possible, I hope I made it