Star Gazr1
asked on
Excel 2010 Vlookup
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
Book1.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're Welcome! Glad I was able to help
ASKER