Best Way to Map this Data

Cross posted here: http://www.excelforum.com/excel-general/724876-best-way-to-map-this-data.html

Please tell people if you are going to also post your question on another forum.

Your examples also appear to be different on each forum. This one seems to suggest you can just do a VLOOKUP.

Dom

Domski said:

Cross posted here: http://www.excelforum.com/excel-general/724876-best-way-to-map-this-data.html

Please tell people if you are going to also post your question on another forum.

Your examples also appear to be different on each forum. This one seems to suggest you can just do a VLOOKUP.

Dom

Click to expand...

Hey Domski

I Post this Query in Another Site After not Getting Any Reply

Its Very urgent for Me.

I Try Vlookup, but Couldn't get Sucess

Can you pls Help Me

I try Your Formula i.e. Vlookup

But not get the Result

Cross Posting http://www.excelforum.com/excel-general/724876-best-way-to-map-this-data.htmlExcel 2007

Think I understand now. For a VLOOKUP to work you need to have exactly the same values in both the item you are looking up from Sheet1 and the lookup table on Sheet2.

Obviously to us Aalooran Rahman Bora is the same person as Aalooran Bora but to Excel they are as different as Bob Hope and Frank Zapper.

You need to work out if there is a logical way to convert the values in names in Sheet1 to the ones in Sheet2. If it was just a matter of getting rid of the middle names that wouldn't be too hard but it looks from the couple of example you posted that it's not that straightforward.

Dom

This might help a little bit but probably won't get you all the way:

http://www.cpearson.com/excel/firstlast.htm

Dom