troubleshooting Question

Excel 2010 Vlookup

Avatar of fjkaykr11
fjkaykr11 asked on
Microsoft OfficeMicrosoft ExcelSpreadsheets
4 Comments2 Solutions178 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros