I'm trying to do something simple with a vlookup but for the life of me it's not working.
E3 contains an email address![]()
=vlookup(E3,AccountList!K:P,1)
AccountList!P column contains a list of email address. Column AccountList!K contains the contact name.
It keeps returning the wrong name. Not the name associated with the email address on AccountList sheet.
Bookmarks