lundi 28 janvier 2019

How can I have my formula show a blank if searched cell is empty?

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