Comp. 2 lists and add data fr one to the othr

leonbwr - Jan 20, 2010 at 04:07 AM
 leonbwr - Feb 1, 2010 at 06:11 AM
Hello, I use excel 2003. I have a list from my phone provider of called numbers. I have a list of contacts with their telephone numbers.

Provider list

Tue 28 Jul 14:26 Mobile 1159410818 02:00 £0.35
Wed 29 Jul 17:04 Mobile 7528625110 02:00 £0.35

list of contacts

Name Company Tel no
Peter X Company x 1159410818
John Doe the doe company 7528625110
Jane doe the doe company 999222992

I need to append the persons name and company to the end of the Providers list, by matching the corresponding phone number to the 'list of contacts'.

Crazy thing is I am sure I have done this before, but i just cannot figure it.. HELP! ..

1 reply

i solved my own problem thanks - the answer is VLOOKUP.