Using linked data in calculated columns

Hi,

Both tables have columns with product and measurment name that are used to link the two tables. The spec table contains in each line a single specification for a single measurement of a single product. The data table has a single measurment result in every line.

Using this link the data table has two additional columns with specification limits. (Both tables have data for several products and measurments)

Each line of the datatable has the limits that are matched to the data point of that line using the names of product and measurment as a link between the tables. Using operators like sun or average will mix all the specs of various products and can therfor not be used. 

My idea is to create a table with in column one the dat from the data table, column 2/3 are the specifications where each line is filled with the values from the spectable that go with the data value in the first column. In coulumn 4 there now should be a 'normalized' version of the data from column 1 using the specs in column 2/3. Each line will therefore use a seperate conversion based on the specs of that line/measurment.

I hope that makes more clear what I need to do here....

Kind regards,

Gajo