Hello - I'm working with a set of experiments where some experiments are dependent on previous experiments (i.e. I'm mixing solutions I've previously made to make new ones). I'm trying to make a function where it reads a column to get the name of the previous solution, searches a second column to find the row with that name, then takes the value in a cell with that row and a third column. Match seems to kindof do this, but I can't get it to work, and I think its in part because match expects an explicitly stated level of the search column, and maybe other stuff I'm not realizing. I'm not at all experienced in JSL and would prefer something like a match column function, but if JSL is what this takes, then that's totally fine.
I've attached a dummy table that should get the point across without seeing all of my extraneous other columns. The last column is the one with the formula that's failing, and here's a screenshot
and the code for what isn't working if that's easier to deal with:
Match( :Solution name, :Used solution for dilution, :Given Concentration ) /
:Dilution Factor
Thanks in advance.
