I have 2 columns in my data table: A if for discount name and B is for day of week. Certain discounts are only allowed to occur on certain day of week. the lookup table has a column for discount name and a column for day of week. I would like this lookup to spit out something for if the discount and day of week match and I would like it to give me an error if the discount and day of week do not match
having trouble coming up with a formula
