I have the following table below, I need help in creating a formula in B4 that will satisfy the Requirements in B1, B2 and B3, on the illustration below, the expected result is Q2
This is my initial formula that is giving an #N/A result
=INDEX(D8:E11, MATCH(1, (B8:B11="Apple") * (C8:C11="Salary") * (D7:E7=G1), 0))
This is my initial formula that is giving an #N/A result
=INDEX(D8:E11, MATCH(1, (B8:B11="Apple") * (C8:C11="Salary") * (D7:E7=G1), 0))
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Company | Apple | |||||
2 | Item | Salary | |||||
3 | Month | Feb | |||||
4 | Result | #N/A | |||||
5 | |||||||
6 | |||||||
7 | Company | Items | Jan | Feb | |||
8 | Apple | Salary | Q1 | Q2 | |||
9 | Apple | Balance | Q3 | Q4 | |||
10 | Samsung | Salary | Q5 | Q6 | |||
11 | Kinkos | Balance | Q7 | Q8 | |||
Sheet1 |