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