Oct 06 2021 08:44 AM
I am struggling to figure out the best way to right a formula that would likely require multiple lookups.
We are trying to pull our insurance premiums for our employees so it will be based on their choices, so it will require multiple conditions and possible look up formulas.
The first item to look up is the age and then based on the age and insurance election, return the value associated with that age group and insurance selection. There are 4 insurance selections. I was thinking a nested vlookup, but I will need an IF statement to look up the age and the insurance plan and then return the value and an I am struggling to figure out the best way to tackle this.
Can someone please help?
Thanks
Oct 06 2021 12:49 PM