Forum Discussion
rossshah
May 05, 2023Copper Contributor
Returning a value after matching multiple criteria
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
- rossshahCopper Contributor
Thank you. It is working.
- Detlef_LewinSilver Contributor
- rossshahCopper ContributorThank you but I have Excel 2016. I don't have IFS function.
- Detlef_LewinSilver Contributor