Originally Posted by
pgruening
Any help would be appreciated, Thanks
I need to know the formula (without using VB) to have the Dental Premium and Extended Health Premium taking from two charts/tables (I can put these on the same worksheet or different worksheet within the same workbook, I have no preference)
For example below:
I enter the name (Test in example), Plan (AA in example), and status (Family in example). I would like a formula that would fill in the Dental Premium and Extended Health Premium from the following two charts/tables.
Name Test
Plan AA
Status Family
Dental Premium $47.00
Extended Health Premium $42.00
[Dental Coverage Extended Health Coverage
Plan Single Family Plan Single Family
AA $20.00 $47.00 AA $22.00 $42.00
BB $21.00 $48.00 BB $23.00 $43.00
CC $22.00 $49.00 CC $24.00 $44.00
DD $23.00 $50.00 DD $25.00 $45.00
E $24.00 $51.00 E $26.00 $46.00
Bookmarks