May 03 2024 08:08 AM
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! :)
May 03 2024 08:29 AM
Solution=INDEX(G2:G15,MATCH(1,(B2=D2:D15)*(B3=E2:E15)*(B4=F2:F15),0))
This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
May 03 2024 08:31 AM
May 03 2024 08:44 AM
May 03 2024 08:46 AM
May 04 2024 03:51 AM
May 04 2024 04:00 AM
Or, with some assumptions
=XLOOKUP(CONCAT(B2:B4), D2:D1000&E2:E1000&F2:F1000, G2:G1000, "")
May 05 2024 10:05 AM
May 05 2024 10:39 AM
May 03 2024 08:29 AM
Solution=INDEX(G2:G15,MATCH(1,(B2=D2:D15)*(B3=E2:E15)*(B4=F2:F15),0))
This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.