IF and VLOOKUP with multiple options

christine.lockwood48061

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.

  

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

=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