Forum Discussion
007Nic
Sep 24, 2022Copper Contributor
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 ...
007Nic
Sep 24, 2022Copper Contributor
Hi Riny, thank you this works with the blank cells excluded and only return the email address. I now get the SPILL error since it is a table and want to return multiple same email addresses. This is due to multiple of the same email addresses where the person are linked to multiple accounts within the database. How can I resolve that I only get one email address.
Riny_van_Eekelen
Sep 24, 2022Platinum Contributor
007Nic Then you need to introduce UNIQUE also. See attached.
- 007NicSep 24, 2022Copper ContributorHi Riny
Thank you for assisting, all is working perfectly. Appreciate.