How do I handle an IFERROR that returns blank instead of an error?

[Matt_has_questions]

Hi all,

Thanks in advance for your help. My formula is below, I've staggered it to show the nesting a bit more clearly. The final Vlookup is not being triggered because my formula is returning blank

=IFERROR(
    IF(V2="","",IFERROR(
    TEXTJOIN(", ",1,VLOOKUP(V2,Props!A:Z,$AH$3,FALSE),VLOOKUP(V2,Props!A:Z,$AH$4,FALSE),VLOOKUP(V2,Props!A:Z,$AH$5,FALSE),VLOOKUP(V2,Props!A:Z,$AH$6,FALSE),VLOOKUP(V2,Props!A:Z,$AH$7,FALSE)),
    VLOOKUP(V2,'Props_all (Opt)'!A:B,$AH$17,FALSE))),"")

Is there an equivalent of IFBLANK, or anyway to make a normal IF statement return the output of the comparison if it's not blank? I suppose having a way to make the TEXTJOIN return an error would also work.

The layout of my sheets are that I have one called Props that contains detailed property addresses, but can miss entries. Then Props_all which doesn't miss any, but only has partial addresses. So I want to lookup the property on Props, and if nothing is returned then fall back to Props_all.

Thanks,
Matt

 

[knigget40]

I am not sure what you are trying to do, but there is an isEmpty() function.

 

[Fluff]

Hi & welcome to MrExcel.
What are the values in AH3 to AH7?

 

[Fluff]

If AH3 to AH7 are consecutive numbers, you could use

=IFERROR(TEXTJOIN(", ",1,FILTER(FILTER(Props!A:Z,Props!A:A=V2),(COLUMN(Props!A:Z)>=$AH$3)*(COLUMN(Props!A:Z)<=$AH$7))),VLOOKUP(V2,'Props_all (Opt)'!A:B,$AH$17,FALSE))

Although I would advise against using whole column references, as it can slow down the workbook.