Forum Discussion

rossshah's avatar
rossshah
Copper Contributor
May 05, 2023

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...
Excel
rossshah's avatar
rossshah
Copper Contributor
May 05, 2023
Thank you but I have Excel 2016. I don't have IFS function.
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
May 05, 2023

rossshah 

 

I did not mention the IFS() function.

 

 

  • rossshah's avatar
    rossshah
    Copper Contributor
    May 05, 2023
    Thank you. It is working.

Resources