Droplist to change table

I might be going crazy but i canīt seem to find an option wich seems very logical to me!

I want to make a droplist in my sheet where i can select a price structure, then there is are different collumns with prices depending on the pricestructure selected.

so i have three price structures with a different name in a sheet.

On another sheet i have 1 column with prices and a dropdownmenu to select the pricestructure. I need this column to assume the values in one of the collumns on the other sheet, based on the pricestructure i select.

I am sure there is a very easy way to do this but i just canīt find it!!

Thanks in advance for your help!

FileForForum.xlsx

I added an attachment,
I hope the meaning is obvious, i have on the left a table from wich the right column has to change depending on the pricstructure selected(1,2,3,4,5)
the price structures are shown on the right in the table

Hope you can help!

Thank you but i managed to solve it myself over the weekend, i made a huge formula with an validation. =IF(A1;....;IF(A1;...;IF(A1;....;IF(A1;...;
it works quit easy like that, i had tot change some numbers when expanding the formula but it worked!