How to find difference between set of requirements

[erkamu]

Hello,
I have the following case.
There are shops that have names A, B, C...Those shops can move from town to town Town A, B, C...
We have set of required items that have to be available in the shop based on 2 rule-Town ID and shop ID.
Those requirements are listed in one database (DB_requirement sheet).
Lets assume that there is a shop located in townA and it has ID ShopA.
Currently that shop have all needed items listed in DB_requirement sheet.
I need to find an easy way when in check_difference sheet I populate the new destination of the shop and or new ID of the shop (for example from TownA-->TownB and from ShopA-->ShopB)
formula to check and list what are the requirements for current combination TownID/ShopID
formula to check and list what are the new requirements for new combination TownID/ShopID
formula to check and list what are the missing items for new combination TownID/ShopID

I am attaching example file of xls
Thanks in advance!

[erkamu]

As there are no replies - please remove the thread. I have posted that question in vba section....

[JeteMc]

If I understand correctly then try:
I2 and down:

Please Login or Register  to view this content.

J2 and down:

Please Login or Register  to view this content.

K2 and down: =IF(J2="","",IF(ISERROR(MATCH(J2,I$2:I$11,0)),J2,""))
If this isn't what you want, please manually fill in columns I:K so that we may attempt to replicate your output using formulas/code.
Let us know if you have any questions.