Forum Discussion

excelmakesmebraindumb's avatar
excelmakesmebraindumb
Copper Contributor
Jul 22, 2025

Vlookup errors

Hello. 7.15 - Sent 4k SMS text messages via mailchimp via an excel import 7.22 - I want to cross reference the master list of phone and emails (6K) to see who updated their email per the SMS reques...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Jul 24, 2025

It looks like there is a space before the phone numbers in column A, but not in column E. Try

=VLOOKUP(" "&E3, $A$3:$B$6431, 2, FALSE)

or if that does not work

=VLOOKUP("*"&E3, $A$3:$B$6431, 2, FALSE)

excelmakesmebraindumb's avatar
excelmakesmebraindumb
Copper Contributor
Jul 24, 2025

Thank you for your response and attempt at trying to help me! 

I did respond below to Branka. If you are unable to see my comment, please let me know.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jul 25, 2025

    Could you attach a sample workbook to a private message to me? Click on my user picture.

    • excelmakesmebraindumb's avatar
      excelmakesmebraindumb
      Copper Contributor
      Jul 25, 2025

      I got it to work! It was the formating in the phone numbers that were different. I re-typed the number I was trying to cross-reference against and then it auto populated all the way down. It worked! I am still getting some N/As. See what was sent for feedback or resolution of N/A. 

      Here are the stats I was able to discern once I got the formulas to work. Let's see if you get the same! 

       

      I am having an issue with my responses not posting. It could be the subject matter. 

Resources