Trying to compare two tables with very specific criteria

[Flaughtbread]

I have a data dump sheet that I than use a filter command into another sheet that filters onto two tables. One for last month and one for current month. My objective is to find any Customers that purchased an item (item code) last month, but have yet to purchase the item code this month. I am at a loss for how to do this because there is not unique identifier between the tables unless maybe you use three identifiers. If it comes back that they have yet to order an item from last month return "Yet to order". If they have Ordered then "Ordered".

There is a possibility that the customer is not in the second table because they have not made any purchases I need that to display "Yet to Order" on all of the ones from the first month.

If the customer is in the second table but not the first I need it to say "Did not order this item last month"

I have sat here for around 10 hours trying to wrap my head around this.

Is this even doable with a formula or am I going to have to do some coding.

[AliGW]

How is this materially different to your other thread?

https://www.excelforum.com/excel-pro...the-month.html

[Flaughtbread]

Apologies I thought I had deleted that since I am no longer looking for a macro. I also changed up quite a few things on my original and updated information with a worksheet.

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread, which you can update accordingly: https://www.excelforum.com/excel-pro...the-month.html