Returning a value after matching multiple criteria

Occasional Contributor

Looking for a formula on cell "I2".  Blue Bike and Press from Table 1 need to match Blue Bike and Press from Table 2, then cell "I2" needs to return a value with qty of 3.   I don't have IFS function available.  Thank you.    




5 Replies
best response confirmed by Hans Vogelaar (MVP)




Thank you but I have Excel 2016. I don't have IFS function.



I did not mention the IFS() function.




Thank you.  It is working.


Thank you. It is working.