Lookup tables & email addresses

Question

I have a Vlookup to a sheet that lists all the suppliers with their email addresses.

In some cases, there are 2 or more email addresses. In the lookup table, they are showing as contacts, but when they are brought into the intake sheet, they are showing up as one of the email addresses and only part of the other one.

What could be going wrong?

Thanks for your help!

Freda

Paul Newcome · Answer

Glad you were able to get it sorted.

FTesseneer · Answer

Hi Paul, when I changed my column back to contacts and allowed for multiple contacts in one cell it worked!

Thank you

Freda

FTesseneer · Answer

Ok, that was one that Copilot missed on then! I have already received a notice from one supplier that they did not receive the email.

So I just reverted back to contact list. I did notice that I did not have that column set so that it could receive multiple email addresses. I will try again.

Freda