If Statement for Blank/Empty Cells

[Nanogirl21]

Hi,

I am using the below 3-way lookup. How would I modify it to return a blank/empty cell if the lookup contains an error or if there isn't any text in the lookup results? The formula i'm using is returning 0 if the lookup is valid, but the lookup results don't contain text.

=IFERROR(INDEX(Attendees!$B$4:$M$45, MATCH(G1&G2,Attendees!$B$4:$B$45&Attendees!$C$4:$C$45,0), MATCH(G5,Attendees!$B$3:$M$3,0)),"")

 

[Eric W]

If what you're trying to return is text, not a numeric value, you can just add &"" to it:

=IFERROR(INDEX(Attendees!$B$4:$M$45, MATCH(G1&G2,Attendees!$B$4:$B$45&Attendees!$C$4:$C$45,0), MATCH(G5,Attendees!$B$3:$M$3,0)),"")&""

It's trickier if you have a number.

 

[Nanogirl21]

If what you're trying to return is text, not a numeric value, you can just add &"" to it:

=IFERROR(INDEX(Attendees!$B$4:$M$45, MATCH(G1&G2,Attendees!$B$4:$B$45&Attendees!$C$4:$C$45,0), MATCH(G5,Attendees!$B$3:$M$3,0)),"")&""

It's trickier if you have a number.

Worked perfectly. Thank you. There isn't any numbers.

 

[Eric W]

I was hoping there weren't any numbers! You'd have to double the size of your formula. I'm glad this worked for you, thanks for the feedback.