Table: Formula to return a value from the table if other cells contain certain values
Hi everyone!
I have a table (like in the screenshot below) that contains certain values in column D/E/F/G. I want to create a formula in which you can enter in the below B2/B3/B4 values from columns D, E and F and depending on the row in the table where all 3 values are true, then B5 returns the corresponding value from column G in that row.
Does anyone have any idea which formulas I could use for this? Thank you so much for your ideas! 🙂
Hi everyone! I have a table (like in the screenshot below) that contains certain values in column D/E/F/G. I want to create a formula in which you can enter in the below B2/B3/B4 values from columns D, E and F and depending on the row in the table where all 3 values are true, then B5 returns the corresponding value from column G in that row. Does anyone have any idea which formulas I could use for this? Thank you so much for your ideas! 🙂 Read More