Forum Discussion
XLOOKUP
Hi I have a database with various customers with their email addresses. I use the XLOOKUP to get the email addresses of a specific person. My problem is that the result bring back "0" value and not ...
Thanks you Riny.
In this scenario there will not be more than one email per person, only blanks. If I can get the email address which ignore all the blank rows it will be great.
In this scenario there will not be more than one email per person, only blanks. If I can get the email address which ignore all the blank rows it will be great.
007Nic Did you see the file I attached earlier? Remove the 2nd email address and the formula will still work. But, if you are 100% sure that there will never be more than one email address per person you could shorten the formula by removing the arguments relating to the TEXTJOIN function (bold red below).
=TEXTJOIN(", ",TRUE,FILTER(contacts[emailaddress],(contacts[fullname]=E7)*(contacts[emailaddress]<>""),""))