Excel如果需要匹配公式帮助

时间:2020-12-08 20:59:37

Can someone please help me with the following excel formula

有人可以帮助我使用以下excel公式

=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

然而,当我将公式向下拖动到空白单元格时,公式显示“售完产品”,我希望公式不显示空白单元格

Excel如果需要匹配公式帮助

Revised Screenshot of Formula and Results

公式和结果的修订屏幕截图

Excel如果需要匹配公式帮助

2 个解决方案

#1


3  

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"),"")

#2


0  

What about this.

那这个呢。

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

#1


3  

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"),"")

#2


0  

What about this.

那这个呢。

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