Sir Babydum GBE
11-27-2007, 06:29 AM
Hi
Please have a look at the attached file.
The master list would be a weekly file I'd receive. My Lookup tabel would really be on a separate sheet - I'd have a new sheet for each "shop" with the same lookups on each.
My problem is that in real life, there may my many hundreds of different products, but I want the individual shop sheets to have tables that display only the products they sell.
However, there may be times where a shop starts a new product - and so I want to be alerted if there is a product on the master sheet in a given shop that is not one of the criteria on that shop's lookup table.
So in I3 and I4 formulas would return "Saw" and "Screws" respectively because the products are present on the master list for shop 1, but missing on shop 1's lookup table.
Can this be done?
Thanks.
Please have a look at the attached file.
The master list would be a weekly file I'd receive. My Lookup tabel would really be on a separate sheet - I'd have a new sheet for each "shop" with the same lookups on each.
My problem is that in real life, there may my many hundreds of different products, but I want the individual shop sheets to have tables that display only the products they sell.
However, there may be times where a shop starts a new product - and so I want to be alerted if there is a product on the master sheet in a given shop that is not one of the criteria on that shop's lookup table.
So in I3 and I4 formulas would return "Saw" and "Screws" respectively because the products are present on the master list for shop 1, but missing on shop 1's lookup table.
Can this be done?
Thanks.