I have cell '$A' searching cell'$N'. Cell '$N' contains a VLOOKUP that pulls a few tags from another data sheet. '$A' searches for two words "CS" & "IG". I need my formula for '$A' to show a blank cell if '$N' has pulled no data.
My formula for '$A' =IFERROR(IF(SEARCH("CS",$N20),"CS"),"IG")
The A column should show CS, IG, or just be left blank.
Aucun commentaire:
Enregistrer un commentaire