Index / Match with multi select criteria
I use a price calculating sheet for various criteria f.e. client or not, booking on short or long term and so on. A possible client uses a form to answer the questions and the price will be shown in another sheet "lead management" and the price will be offered to the interested people by an automation process.
Is it possible to change the formula using multi select criteria - in the example sheet
column "Extras" a client would choose f.e. if he/she wants
- accomodation (Unterkunft) = 1.449,42 € and also
Help Article Resources
Check out the Formula Handbook template!