Auto populate fields based on lookup table

If i have a form with the following filled out and want to reference a lookup table how can this be done?

See below:

Split= Y,

Deal Type = Exclusive

Sub-Type = CoBroke

Can you please provide us ID of your form where you want to achieve this? And if you can, please explain in more details your request? 

Not sure exactly what you want to achieve but you can use our conditional logic to make some 'searching'. You can try with conditions "contains" to make a search of sorts.

http://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic 

Looking forward to your reply. 

The form is not yet created, i don't want to create it until I get the answer to my question.  See below for better explanation.  Imagine, a user inputs certain values for the following fields, where:  Field= 'Value',

Split= 'Y'

Deal Type= 'Exclusive'

Sub-Type= 'CoBroke'

Primary Agent= 'Test1'

Primary Agent %=  '** this is where I need the table lookup to occur**'

I need the Primary Agent % 'value' to return the intersection at 3A because the inputs above Primary Agent % are:

Deal Type = Exclusive

Split = Y

Sub Type = CoBroke

Therefore Primary Agent %=  what is in cell 3A = 20

The LOOKUP TABLE will be in excel format.  See example below

Hi,

Unfortunately, we do not have a lookup table, but this is possible using conditional logic. Here's an example:

IF Deal Type = Exclusive AND

IF Split = Y AND

IF Sub-Type = CoBroke

THEN

Primary Agent % = 20

Here's a sample form: http://form.jotformpro.com/form/51028864393965.

The screenshot below will show how I did mine:

1. Add drop down fields for the input of your data.

2. Add the Form Calculation widget to fetch the value you need for each condition.

3. In your "Conditions Wizard", choose "Update a form field value".

4. I will then set the rules that will be based on the lookup table that you have.

I hope this helps.

Kind regards.