IF and VLOOKUP with multiple options

Trying to summarize from a worksheet to another (summary worksheet).  The VLOOKUP should give an "X" if includes "August" and instead gives the same answer for every search since there are multiple of the original search; it's saying yes since it saw it the first time, but shouldn't if actually missing.

Original worksheet sample and summary worksheet with formula below.  Thank you in advance for your time and assistance.

Original Worksheet  Formula from Summary Sheet

Worksheet.png

formula.JPG

Tags:

Comments

  • L_123
    L_123 ✭✭✭✭✭✭

    =if(count(collect([auction name]:[auction name],[auction name]:[auction name],@cell = [APR Auction]@row,[Month Reviewed]:[Month Reviewed],@cell = "August"))>0,"X","0")

     

    Untested, you need to replace the auction name and month column references with other sheet references.

  • L_123
    L_123 ✭✭✭✭✭✭

    =if(countifs([auction name]:[auction name],[APR Auction]@row,[Month Review]:[Month Review], "August")>0,"X","0")

     

    That one is a little more simple I suppose. Still need to change the column references to other sheet references though

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!