TruffleOil
New Member
- Joined
- Sep 9, 2022
- Messages
- 18
- Office Version
- 2016
- Platform
- Windows
I have a table with four different criterias which will result in 4 diff values (see picture attached).
I will then have two dropdown menus for the criterias: Select X or Y, and select U or V, which will then show the result in common. so an example: if between X and Y we select X and between U and V we select V, we'll get 30 based on the table.
I'm looking for a formula that will show the final result (30 in this example) based on those criterias. I have Excel 2016 so the IFS formula doesn't work for me..
Thank you in advance!
I will then have two dropdown menus for the criterias: Select X or Y, and select U or V, which will then show the result in common. so an example: if between X and Y we select X and between U and V we select V, we'll get 30 based on the table.
I'm looking for a formula that will show the final result (30 in this example) based on those criterias. I have Excel 2016 so the IFS formula doesn't work for me..
Thank you in advance!