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
--
pgruening
------------------------------------------------------------------------
pgruening's Profile:
http://www.excelforum.com/member.php...o&userid=26011
View this thread:
http://www.excelforum.com/showthread...hreadid=394693