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