Come Together!

[Ascelpius]

I regularly deal with data lists of 20k records. Each row is an address. I have another spread sheet that is essentially a list of all UK post code districts (about 2,500 of them) in one column, and a corresponding sales agent in the next.

I need a way of marrying up the two lists so I can append a sales agents' details onto each of the addresses on the massive list.

Any suggestions?

Cheers

 

[Ascelpius]

Please reply quickly!

 

[lenze]

Sounds like VLOOKUP would work!!

=VLOOKUP(D2,AreaList,2,0)

where D2 has the Postal Code in you address Table and AreaList (Named Range)is the Table with Post codes and sales reps. Adjust as needed

lenze

 

[Ascelpius]

Works a treat - job's a good 'un!

Cheers lenze!