hi guys.
im in need of some help
i got a tables of data :
health table = on the A column name of insurance coverage, column B:E shows discount level 1,column F:I shows discount level 2, column J:M shows discount level 3.
risk table = on the A column name of insurance coverage , column B is the min. age , column c is the min. coverage sum
compensation table = on the A column name of insurance coverage, column B:I the discount percentage
bundles = on the A column name of insurance coverage, column B:I the discount percentage
on top of all i have slicer that shows all the coverage names (health and risk, compensations and bundles).
i would like help on 4 things :
1. if the chosen coverage in the slicer is under the risk table - popup input box 2 criteria - (age, sum coverage) - then it will Vlookup by the 3 criterias (name(chosen in the slicer),age,sum), and will show the proper discount row
2. if the chosen coverage in the slicer is under the health table - popup input box with 2 crieiria (price, level of discount) then it will vlookup by the covrage name ,it will put the input in cells (under column F - price) and will show the proper discount row.
3.if the chosen coverage in the slicer is under the compensations table and its "Top light" - popup box with 3 options of discount -"choose one"
3a. if the chosen coverage in the slicer is under the compensations table and its "Life money" - check box with 2 lines : 1. "min age 21?, 2. min cov. 100K?"
4. if the chosen coverage in the slicer is under the bundles table and its "premium" - popup box with 3 options of discount -"choose one"
Thanks a lot everyone!
here are my tables
im in need of some help
i got a tables of data :
health table = on the A column name of insurance coverage, column B:E shows discount level 1,column F:I shows discount level 2, column J:M shows discount level 3.
risk table = on the A column name of insurance coverage , column B is the min. age , column c is the min. coverage sum
compensation table = on the A column name of insurance coverage, column B:I the discount percentage
bundles = on the A column name of insurance coverage, column B:I the discount percentage
on top of all i have slicer that shows all the coverage names (health and risk, compensations and bundles).
i would like help on 4 things :
1. if the chosen coverage in the slicer is under the risk table - popup input box 2 criteria - (age, sum coverage) - then it will Vlookup by the 3 criterias (name(chosen in the slicer),age,sum), and will show the proper discount row
2. if the chosen coverage in the slicer is under the health table - popup input box with 2 crieiria (price, level of discount) then it will vlookup by the covrage name ,it will put the input in cells (under column F - price) and will show the proper discount row.
3.if the chosen coverage in the slicer is under the compensations table and its "Top light" - popup box with 3 options of discount -"choose one"
3a. if the chosen coverage in the slicer is under the compensations table and its "Life money" - check box with 2 lines : 1. "min age 21?, 2. min cov. 100K?"
4. if the chosen coverage in the slicer is under the bundles table and its "premium" - popup box with 3 options of discount -"choose one"
Thanks a lot everyone!
here are my tables