Excel If Match Formula Help Needed

Question

Can someone please help me with the following excel formula

=IF(ISERROR(MATCH(A81,$E:$E,0)),"Sold Out Product","Existing Product")

The formula works however, when I drag the formula down to blank cells the formula displays “Sold Out Product” and I would like the formula to display nothing for blanks cells

Revised Screenshot of Formula and Results

Answer 1

Just wrap it to test if the cell is empty :

=IF(A81<>"",IF(ISERROR(MATCH(A81,$E:$E,0)),"Sold Out Product","Existing Product"),"")

So for the 2nd row :

=IF(A2<>"",IF(ISERROR(MATCH(A2,$E:$E,0)),"Sold Out Product","Existing Product"),"")

Answer 2

What about this.

=IF(ISERROR(MATCH(A81,$E:$E,0)),"","Existing Product")