Google Sheets Array If Condition

Question

我有下面的公式，它运行良好，并返回预期的结果。

=ARRAYFORMULA(iferror(if(row(I:I)=1,"CE Credit",
if(A:A="","",
VLOOKUP(I:I&" "&U:U,importrange("abc123","Course Catalog Database Export!E:N"),3,0))),"!!!"))

我需要添加一个条件。如果vlookup结果大于0，我希望它返回Yes，如果不是No。

=ARRAYFORMULA(iferror(if(row(I:I)=1,"CE Certificate Needed",
if(A:A="","",
if(VLOOKUP(I:I&" "&U:U,importrange("abc123","Course Catalog Database Export!E:N"),3,0)>0,"Yes","No")),"!!!")))

但是标题显示为空，并且没有显示结果？

Answer 1

try:

={"CE Certificate Needed"; ARRAYFORMULA(IFERROR(
IF(A2:A="",,IF((VLOOKUP(I2:I&" "&U2:U, 
IMPORTRANGE("abc123", "Course Catalog Database Export!E:N"), 3, 0)*1)>0, "Yes", "No")), "!!!"))}