Dec 29 2021 10:29 AM
Hi there,
I am trying to create a way for my price list to become dynamic. You would have to select a package, then a company size and I want it to automatically assign the price based on the prior two selections. The problem is that there are many different combinations so I am struggling to get my function to run through the various options. I can get it to work for a single option.
Any suggestions?
Thank you in advance!
Dec 29 2021 10:31 AM
Dec 29 2021 10:52 AM
Solution=VLOOKUP(E2&F2,CHOOSE({1,2},A2:A16&B2:B16,C2:C16),2,0)
Is this what you are looking for? Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021. Dropdowns are in E2 and F2 in my example.
Dec 29 2021 11:29 AM
@OliverScheurich this is awesome. Thank you and Happy New Year!
Dec 29 2021 10:52 AM
Solution=VLOOKUP(E2&F2,CHOOSE({1,2},A2:A16&B2:B16,C2:C16),2,0)
Is this what you are looking for? Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021. Dropdowns are in E2 and F2 in my example.