Hello everyone!

I have a problem that I am sure can be helped with excel any help would be much appreciated!

List one is a list of names and a number relating to where they came from ie

Mr Jason Smith 456
Mrs ayleen Smith 122

etc in alphabetical order, several thousand records.

I then have another list of customers who purchased something this is just the customer name (several hundered records)

I would like to be able to quickly match up MR Jason Smith 456 with the corresponding sale so I can work out if there is a trend between the customers that made a purchase and where they come from

at the moment I put the lists side by side and search each name individually then make a note of the source number, this is quite time consuming!

Any ideas on how I could do this more efficiently?

Thanks

Jason