Reference a Table To Fill Sheet From A Form

[fmexcel]

I made a form with 3 different Combo Boxes, "Age, Gender, Coverage"
I want to be able to apply the selected items to a sheet but I only need the value of the table when all three are applied to populate the cell in the sheet.
For example:
I open the form, select "Male, 18, 250K" click button apply and have it pull the value on the table that corresponds to all 3, "X"

I'm no sure how to link the table to the drop down buttons.

 

[Roderick_E]

Sometimes it's easier to think of thinks as a sheet formula first. So, for you example, let's suppose
Col A = Ages
Col B = Genders
Col C = Coverage
Col D = Value to return if all 3 match

In cell F1 you have this formula:

=INDEX(D:D,MATCH(18&"Male"&250000,A:A&B:B&C:C,0))  ctrl+shift+enter to make array

This will return the matching value in Col D.
Hope it will help you think it through.