Hi,
I have 2 seperate files with over 500 customers details. my problem is that one spreadsheet shows both their name and customer ID (seperate columns) and the other shows just their customer ID. In the 2nd file how can I replace the customer ID's with their names? (the numbers are not allocated based on alphabetical order)
use Vlookup function
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
use VLOOKUP in another column....
e.g.
=VLOOKUP(A2,'Sheet1'!A:B,2,FALSE)
copied down.
you may need to replace Sheet1 with entire path to other workbook...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
solved thank u
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks