Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I have an array of values:
A B C
1 TypeID MaterialTypeID Quantity
2 18 34 256
3 18 35 512
4 20 34 386
5 20 36 773
Now I need a formula where I can search for lets say TypeID=20 and MaterialTypeID=34 and the formula gives me the Quantity=386.
Ok, I found the solution:
where D6 and D7 are my search criteria...
I think this might be another, maybe easier, way to do it:
=QUERY(A2:C5, "SELECT C WHERE A=20 AND B=34")
Required, but never shown