Excel 2007 : Pulling Across Names / Phone Numbers / Addresses?

Maybe a VLookup?

Indeed it is - Monkey Island reference!! one of the best games ever!!

Hmm, I'm trying to use VLOOKUP, but I'm terrible with it (to be perfectly honest, with Excel in general :p).

Any advice? And it turns out I have a phone number to match up (not, in fact, customer ID). It's in the leftmost column in one of the spreadsheets (the spreadsheet I want to move stuff to) but not in the other one.

I can easily drag the columns across, though, obviously.

Originally Posted by TMShucks

You're more likely to get a constructive answer if you post a sample workbook.

Regards

Will do! :D

The bulk list is the one that needs the name and email (ignore my silliness with the telephone, that's what the DN is) introduced. Reduced the column width so there's no issues and you can see where the stuff is.

Thanks in advance,
Bob

You can use INDEX/MATCH as per TMS's idea, for the Name, from your example, something like:

=INDEX([Sample_Customer_List.xlsx]Sheet1!$A$2:$A$4,MATCH(Sheet1!B2,[Sample_Customer_List.xlsx]Sheet1!$S$2:$S$4,0))

As to a description, have a look here http://www.randomwok.com/excel/how-to-use-index-match/

This has worked for the contact email as well. :D

Thank you both very much for all your help!