Subsequent rows dependent on different columns from previous rows
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 se...