Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
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.
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.
VBA Code:
=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)),"")