compare and copy data

**phenonm** · 08-21-2010, 08:14 AM

Hi There

I have run into an issue with excel that's a little beyond my amateur coding skills

I think this can be solved with some simple vbscript or nested excel formula

All i need to happen is to compare a list of names and one additional value to another list of names and add the missing value. Easier if i give an example of data

the columns are as follows

Column A Column B Column C Column D
Name Value Name Value
Bob, Test Full Bart, Test
Bill, Test Part Bob, Test
Ren, Test Non Bill, Test
Bart, Test Part Ren, Test

So in column A and B is the reference data, and you see Column C and D is where the data needs to be matched / copied to. The script / formula needs to in this case work its way down column C - look up the matching value in column A and then copy whats in column B next to the matching value to column D.

Example is with the above data it would first hit in column C - Bart, Test - it would then lookup cell A for Bart, Test - and copy whats in column B beside it which is "Part" to blank cell in column D

Then it would move on to Bob, Test in column C - it would then lookup cell A for Bob, Test - and copy whats in column B beside it which is "Full" to blank cell in column D

I have a massive list of 3800 names that gets emailed to in a jumbled order and may grow in cell numbers as well so i cant count on a simple A to Z sort to help out - with additional information that i need to marry up to my existing data. I need an easy way to have it find the same name in my data and copy in the additional information provided.

Any ideas on a formula or vbscript that could do this - i appreciate it in advance

Cheers

Phenonm

**royUK** · 08-21-2010, 08:22 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

EDITED THIS TIME

**royUK** · 08-21-2010, 08:22 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**phenonm** · 08-21-2010, 09:25 AM

Hi

Sorry for posting an incorrect title - appreciate you setting me straight

Excel attached with expected results

hope this clarifies

Cheers

Matt