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