cmschmitz24
Board Regular
- Joined
- Jan 27, 2017
- Messages
- 150
Hello,
I need help writing a nested if statement:
I need to pull a value into cell A53 on sheet "SL Estimate" from sheet "Year 1 Rates" based on drop down selections in 5 different cells on sheet "SL Estimate".
Drop down cells used:
Cell E8, named "Cov_Level", has either Single-1 or Family-15
Cell F8, named "Health_Plan", has a list of 18 plans located on sheet "Year 1 Rates" A5:A22 (this will be the starting point to find the value)
Cell I8, named "HDHP", has either non-HDHP or HDHP
Cell J8, named "Dental", has either With Dental or Without Dental
Cell K8, named "Rate", has either Full Time or Less Than Half Time
On sheet "Year 1 Rates", there are the different rate values for each situation above, in columns B:AW
Full Time, non-HDHP, with Dental, single, values are in column B
Full Time, non-HDHP, with Dental, family, values are in column E
Full Time, non-HDHP, without Dental, single, values are in column H
Full Time, non-HDHP, without Dental, family, values are in column K
Full Time, HDHP, with Dental, single, values are in column N
Full Time, HDHP, with Dental, family, values are in column Q
Full Time, HDHP, without Dental, single, values are in column T
Full Time, HDHP, without Dental, family, values are in column W
Less Than Half Time, non-HDHP, with Dental, single, values are in column Z
Less Than Half Time, non-HDHP, with Dental, family, values are in column AC
Less Than Half Time, non-HDHP, without Dental, single, values are in column AF
Less Than Half Time, non-HDHP, without Dental, family, values are in column AI
Less Than Half Time, HDHP, with Dental, single, values are in column AL
Less Than Half Time, HDHP, with Dental, family, values are in column AO
Less Than Half Time, HDHP, without Dental, single, values are in column AR
Less Than Half Time, HDHP, without Dental, family, values are in column AU
Please help!
I only have =VLOOKUP(Health_Plan, 'Year 1 Rates'!A:AW,
I know I have to start my nested if statements but I'm not quite sure how to finish/complete it.
I need help writing a nested if statement:
I need to pull a value into cell A53 on sheet "SL Estimate" from sheet "Year 1 Rates" based on drop down selections in 5 different cells on sheet "SL Estimate".
Drop down cells used:
Cell E8, named "Cov_Level", has either Single-1 or Family-15
Cell F8, named "Health_Plan", has a list of 18 plans located on sheet "Year 1 Rates" A5:A22 (this will be the starting point to find the value)
Cell I8, named "HDHP", has either non-HDHP or HDHP
Cell J8, named "Dental", has either With Dental or Without Dental
Cell K8, named "Rate", has either Full Time or Less Than Half Time
On sheet "Year 1 Rates", there are the different rate values for each situation above, in columns B:AW
Full Time, non-HDHP, with Dental, single, values are in column B
Full Time, non-HDHP, with Dental, family, values are in column E
Full Time, non-HDHP, without Dental, single, values are in column H
Full Time, non-HDHP, without Dental, family, values are in column K
Full Time, HDHP, with Dental, single, values are in column N
Full Time, HDHP, with Dental, family, values are in column Q
Full Time, HDHP, without Dental, single, values are in column T
Full Time, HDHP, without Dental, family, values are in column W
Less Than Half Time, non-HDHP, with Dental, single, values are in column Z
Less Than Half Time, non-HDHP, with Dental, family, values are in column AC
Less Than Half Time, non-HDHP, without Dental, single, values are in column AF
Less Than Half Time, non-HDHP, without Dental, family, values are in column AI
Less Than Half Time, HDHP, with Dental, single, values are in column AL
Less Than Half Time, HDHP, with Dental, family, values are in column AO
Less Than Half Time, HDHP, without Dental, single, values are in column AR
Less Than Half Time, HDHP, without Dental, family, values are in column AU
Please help!
I only have =VLOOKUP(Health_Plan, 'Year 1 Rates'!A:AW,
I know I have to start my nested if statements but I'm not quite sure how to finish/complete it.