Help in configuring a result that needs to use "LOOK UP" in a range that will be contained (existing) in the same form?

have you any examples of a calculation that needs to use "LOOK UP" in a range that will be contained in the same form?

I want to 'LOOK UP' for a value/result in a serious of cells in order to get a result 

when we use this margin table in a spread sheet- this is what w ehave in the field that we want the result of teh LOOK Up to be populated into

=VLOOKUP(FieldX,margintable,2,1)

this is an example of the margin table:

Can this be done in JOTFORM?

Unfortunately, the VLOOKUP function is not available at JotForm.

JotForm Calculation - Math Function Reference

If am not sure if this is something that may work in your case, but it is possible to assign values to the field items.

How to Assign Calculation Value

For example, if you have a dropdown you can assign different values to different dropdown items.