I’ve got a separate table with the prices of construction materials like plywood. It has different thickness and varies in price depending on it. I created a drop down menu where you can select the type of plywood for calculation
I want to have a dynamic price depending on the plywood’s thickness. I was trying to use the =IFS formula for it, but it doesn’t work for me. My thinking is, that it’s because I don’t put in a set string value in it, and instead my formula looks like this “=IFS(J6=PLW18; H7; J6=PLW21; H8)”
The H column is where I store the prices for plywood, and the J6 cell is where the drop down menu where you can select the type of plywood is. Does anyone know of a way to make this idea work?
Welcome @MScalc ! (what an interesting nickname you chose for yourself - unexpected 
)
It is difficult and simple to answer your question at the same time.
Simple: The idea with the IFS() function will not work.
Difficult: Most likely, you will need LOOKUP() or INDEX(MATCH()). But perhaps you will need not Calc with its functions, but Base with its queries. No one can answer you in detail - we do not see how you organized the data in your spreadsheet and how you are going to process it. To get quick help, attach a sample file to the original question or to the next comment, then we will talk.
1 Like