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
.
Best Answer
Ok, I found the solution:
where
D6
andD7
are my search criteria...