I have 2 formulas that work by themselves, BUT need them to merge together into one formula (keep getting errors). Just trying to say if the cell I'm referencing in Column D contains the word "REGION" then do not return a value from it. Otherwise if it IS in the pivot table I am referencing then needs to say "Strategic"
=IF(COUNTIF(Master_4.21!H$5:$H$43,D14),"Strategic","")
=IF(SUM(COUNTIF(D14,{"*REGION*"})),"")
Thanks in advance!!!!
Bookmarks