Forum Discussion
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 colu...
=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.
Thank you so much for all your help! One more challenge, it should now do the same, but B3 can now be a value in a certain range. So if B3 is <= 25999 it should return the value in G that belongs to the combination with 25999, if B3>25999&<=26999 it should return the value in G that belongs to 26999, if B3>26999&<=36999 it should return the value in G that belongs to 36999 and so on.
Any ideas? I played around a lot with "ifs" and "ands" but no luck yet....
Any ideas? I played around a lot with "ifs" and "ands" but no luck yet....
