I have some large customer tables which have discounting information in them. The format of the tables is:
A B C D
Customer Number Condition Type Material/Variant Amount
20004524 ZSTA MNDGY327 -35
20004525 ZSTX NTFDE4765 -25
20004525 ZTFA 264587 -30
I currently an using SUMPRODUCT on the Calculation Sheet, based on the 4 input values, to bring in the amounts based on the references: CUSTNUMBER, CONDNUMBER, VARNUMBER & AMTNUMBER, which are simply columns A, B, C & D, respectively. This works great for price calculation.
The problem is when the value on the Calculation Sheet is "0.00", there's no way to tell if the discount is actually loaded in the table at 0.00 (this happens sometimes) or if there is no discount loaded in the table. I'd like to add a cell to the calculation sheet that will verify for the user whether it is already loaded at "0" (no message) or if it's missing (i.e. " Please load missing ZSTA condition for this account"), etc.
I would assume that this would be a variation of what I'm already using but not certain. Any help on this would be most appreciated.