Forum Discussion

Copper Contributor

May 03, 2024

Solved

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...

excel

Excel for web

Formulas and Functions

OliverScheurich
May 03, 2024
Meerande
=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.
Formula to return a value from the table if other cells contain certain values.xlsx9 KB

OliverScheurich

Gold Contributor

May 03, 2024

Meerande

=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.

Formula to return a value from the table if other cells contain certain values.xlsx9 KB

Meerande

Copper Contributor

May 03, 2024

Oh awesome, thank you so much, that was so quick! Works perfectly 🙂

Rui_Dias_Ruca
Copper Contributor
Feb 18, 2025
Dears...help :-)
I have one work sheet where I have a table and values with several names, so whenever it will be in line x a specific value and then in line X+1 another value I need to return a value, please
I need to know the plan "Line 12" if per month it was done or not "Line 13" with values, example for "Jun" was planned 4 and was done 4 so 100% covered

I really appreciate your help