Ahh, I see. We can definitely consolidate your dropdown by using INDIRECT and VLOOKUP.
Somewhere on another tab store the translations. I named that sheet Reference.
A2: Kuř
A3: Vepř
B2: Kuřecí
B3: Vepřové
etc
Your validation formula:
=INDIRECT(VLOOKUP(B13,Reference!$A$2:$B$8,2,0)&"!$A$3:$A$52")
Bookmarks