Excel 2010 Vlookup

fjkaykr11
fjkaykr11 used Ask the Experts™
on
I am attaching a sample Excel file.  On Sheet 1 column A are phone numbers.  on Sheet 2 in Column A is a list of the phone numbers and in Column B is updated phone.  In column B (Sheet 1), I want write a Vlookup to Column A (Sheet 1) and then find a Match in Column A (Sheet 2) and bring back the Updated Phone Number Column B (Sheet 2) into Column B (Sheet 1).    I am working on a much larger Excel file the sample file,  but it's not working correctly (only some of the numbers are populating). So I think I might be doing the Vlookup incorrectly.   Any info is greatly appreciated, thank you.
Book1.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Hi,

Please attache a sample which are not updating correctly, in your attached sample, simple vlookups works:
=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,0),"")
Vlookup
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Try with the wild card, sometimes query uploaded data may have extra spacing:
=IFERROR(VLOOKUP("*"&A2&"*",Sheet2!A:B,2,0),"")

Author

Commented:
Thanks for your help I really appreciate it
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
You're Welcome! Glad I was able to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial