I mocked up your data with the headers "Dental Plan, Single, Family" in
cells A2:C2 and the associated data in A3:C7. "Health Plan, Single,
Family" in cells E2:G2 and associated data in E3:G7. I used row labels
"Name, Plan, Status, Dental Premium, Health Premium" in A10:A14. The
formula for the dental premium in cell B13 is
=VLOOKUP(B11,$A$3:$C$7,MATCH(B12,$B$2:$C$2,0)+1,0)
The formula I used for the health premium in B14 is
=VLOOKUP(B11,$E$3:$G$7,MATCH(B12,$F$2:$G$2,0)+1,0)
|