Hello. I have a table that it is filled using a forms. there are two fields coming from two other tables that are selected by the customer.
I need a formula column where it analyzes the two filled fields and returns the result (remuneration) based on a third table (remuneration_table).
below I am attaching a photo to illustrate.
basically I need the formula to return the candidate’s remuneration based on the sector and position he will be hired.
Could someone help me?