Hello
Firstly, please confirm that my understanding is correct
The translation pertaining to the selected item from the dropdown is supposed to be retrieved from the "List of translations" sheet and should be updated accordingly in the next 2 consecutive columns on the first sheet.
If my understanding is correct then I can get this done in less than an hour.
My approach ( ie, if my understanding is correct ) -
User select an item from the dropdown.
The Macro searches for the 'EXACT" text on the next sheet and gets the translated text from the corresponding ROW ( col 2 & 3 ) and updates it in the corresponding columns in the first sheet.
Please confirm and do contact me. I willing to stand corrected if my understanding is wrong
Regards