2 lists of data I need to compare and a formula to match up

[Jashebb]

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

[Pete_UK]

Take a look at this thread from a couple of days ago:

http://www.excelforum.com/excel-form...-position.html

It seems very similar to what you want to do.

Hope this helps.

Pete

[Jashebb]

Thanks Pete

If I just want to match by name do I change your formula:

J2: =IF(ISNUMBER(MATCH(C2,G:G,0)),C2,"") from ISNUMBER to ISTEXT? or is there another term used?

Thanks!