Similar functionality as XLOOKUP() from Excel in JMP?

[#1]

I have a data table where for each measured value the batch (#XXXX, #YYYY, #ZZZZ#), the storage temperature (5, 25 or 40) and the storage time (0, 3, 6, 9, 12) is specified. The idea is to subtract from each measure value the value with a storage time of 0 and the same batch and storage time as the in the row. 
I was able to slove this in excel with XLOOKUP(). Is this also possible in JMP?

[#2]

Please have a look at Col ...()  aggregation - they are much more powerful than XLookup().

In the Marketplace you can find the Normalization GUI.
It can be used to calculate the difference y - and many other cases ...
https://marketplace.jmp.com/appdetails/Normalization+GUI

[#3]

Maybe I am wrong but to my understanding this does not resolve the current issue and there maybe an overview on the Col funtions available?

[#4]

This file would be an example for such a table. And for each data set within the table the correct T=0 should be used for calculating the difference and the correct one is the one from the same batch and the same temperature, but also the storage time =0. I hope this makes it a bit clearer. 

[#5 · Accepted solution]

Based on your example data, the smallest Measured Value is always for Storage Time = 0, is this always true? If this is the case you can use Col Min

:Measured Value - Col Min(:Measured Value, :Batch, :Temperture)

And if this isn't always the case you need a bit more complicated formula

:Measured Value - Col Min(If(:Storage Time == 0, :Measured Value, .), :Batch, :Temperture)

[#6]

Thank you, that works!