Hello world!
I have a two long lists of Car manufacturers (including a code)
I need to go though the lists to find identical values in the two lists.
If there is a match between the two values, the code and name of manufacturer from sheet one must be added to sheet two.
ex.PNG
I hope it is not too confusing.
Br,
Thue
Last edited by ThueO; 09-11-2014 at 08:19 AM.
Please upload a sample file
Cobwebs, Alba Gu Brath (Scotland Forever)
That can be done.
Are you able to upload an small excel file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
http://www.filedropper.com/ex_1
Here it is.
Last edited by ThueO; 09-11-2014 at 08:24 AM.
Please post the excel file here on the forum.
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
I don't see a paperclip
but it's here: http://www.filedropper.com/ex_1
With index / match for column C
With Vlookup for column D
See the attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks