Setting a column value based on multiple conditions
Hi, I'd like to find a value on a 'CD' column based on 'Depth' value, for corresponding 'Wafer' and 'Lot ID'.Below is the example table I created, I have multiple 'CD' values at different 'Depth' values, and there are multiple 'Wafer' and 'Lot ID' for each specific wafers. What I need to find is 'CD' value at 20nm 'Depth', to create normalized CD plot. I know I can use 'Col Mean' if I am to normal...