Pulling Across Names / Phone Numbers / Addresses?

**bobbertr** · 10-24-2011, 06:16 AM

Just wondering if there's a way to move data from one spreadsheet to another and match it up to postcodes?

To explain:
I have two spreadsheets. Both spreadsheets have two bits of data that link them up (customer number and post code). I need to bring info (address / phone number / name) from one spreadsheet to the next based off the postcode or customer number.

Thank you in advance,
Bob

**Kyle123** · 10-24-2011, 06:21 AM

Maybe a VLookup?

**TMShucks** · 10-24-2011, 06:26 AM

Possibly Index/Match, concatenating the customer number and post code. But is the customer number not unique? In which case, as Kyle 123 has said, a VLOOKUP might work ... if the customer number is in the leftmost column.

@Kyle123: is that a three headed monkey?

Regards.

**Kyle123** · 10-24-2011, 06:31 AM

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

**bobbertr** · 10-24-2011, 06:37 AM

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.

**TMShucks** · 10-24-2011, 06:40 AM

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

Regards

**TMShucks** · 10-24-2011, 06:42 AM

@Kyle123: ah, bite, chew, swallow ... means nothing to me ... not a game player. Regards

**bobbertr** · 10-24-2011, 06:52 AM

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

**Kyle123** · 10-24-2011, 07:02 AM

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/