I have a formula that is listing whether or not a sales deal is active, but I just realized that some of the ship IDs in (Deals! G:G) are blank, when searching with (Pricing Lookup '!$B$1). My question is when Deals!G:G is blank can I have it search (Pricing Lookup '!$B$3) searching in (Deals!K:K) next? The current formula is looking up ship to location and checking for a sales deal, I would like the new formula to check that first but if blank then search the sold to to check for a sales deal. I have either a sales deal for the ship to or a sales deal for the sold to.
=IF(COUNTIFS(Deals!G:G,'Pricing Lookup '!$B$1,Deals!N:N,'Pricing Lookup '!$A9,Deals!E:E,"<=" &'Pricing Lookup '!$B$6,Deals!F:F,">=" &'Pricing Lookup '!$B$6),"Active","")
Bookmarks