Forum Discussion
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...
Hi there,
in your scenario the VLOOKUP formula could look like this:
If there is a match, the column "Updated profile" will return the email address which was updated. If there is no match, formula will return 0.
Hope this helps!
Branka Kajiš, MCT
Hello,
Thank you so much for your reply. It is greatly appreciated. I sent a message earlier letting you know that I was unable to get your example to work and I replicated yours exactly! I have removed all formating from the cells to keep trying.
I am getting this response.
My table array has 6431 records. When I have tried the formula by substituting the $B$9 for $B$6431 it also failed. I am sure I am doing that wrong!
I appreciate your logic!