Hi
JDR Projet.ods (17.2 KB)
Using LibreOffice 24.2.7.2 X86_64 on Linux Mint (latest)
I’m trying to do a drop-down list (easy) which, when an item is selected, will fill adjacent cells to matching entry values.
It’s about a browser RPG, the table is a damage calculator depending on the weapon, then i’ll enter all modifiers.
Each weapon from the drop-down list will then change different damage outputs but for now, i just want the drop down list to auto-fill N3 and O3 (min weapon damage and max weapon damage)
I plan to have a data sheet and a main sheet.
Main is called JDR
Data is called Data
In the joined table, i’ve highlighted the cells involved.
Main:
M3 = drop-down list
N3 = Data1 depending on M3 match
O3 = Data2 depending on M3 match
Data
A3:A5 = list values
Here it’s
Fronde
Arc Recourbé
Arc de Chasse
B3:B5 = Min weapon damage (Data1)
C3:C5 = Max weapon damage (Data2)
I’ve spend quite some time with ChatGPT to solve this but nothing worked.
Also watched a few videos but even if i’ve made some complex tables in the past, i’ve always stuck to a few simple functions and never used index or match.
Sometimes, the result were extremely long formulas.
I’m trying to level up a bit my calc skills 
GPT tells me do use =IFERROR(INDEX(Data.$B$3:$B$5;MATCH(M3;Data.$A$3:$A$5;0));"") in N3
the problem is the only way I can display the list correctly in M3 is by writting the list in Data > Validity
GPT offered me plenty of solutions to do it differently but none worked.
And when i write the list, the drop down list works but the formulas for matching Data in N3 and O3 don’t…
From a video, I deducted something like this in N3 =INDEX(B3:B5,MATCH(M3,$Data.A3:$Data.A5))
But it doesn’t work either.
Could someone help me here, I’ve no idea about what i’m doing 
Thanks in advance
Have a nice day