tommytowbar
wrote in :


excellent work !

thanks for that

no more sleepless nights





I'll echo George's previous comments. Maintaining the discounts in a
separate table is the way to go.

There are a few ways to get the needed discount from the table. I prefer
INDEX & MATCH, VLOOKUP is also popular.


-RP