VLOOKUP similar names problem

[rob_ford16]

Hi,

I have a list of place names in column A. I need to reference those place names in a list and return a number.

Example:

	A	B	C	D
1	Federated States of Micronesia	Micronesia (the Federated States of)	498	=vlookup(A1&"*",B1:C10,2,true)
2	Micronesia
3	The States of Micronesia
4

<tbody>
</tbody>

I tried doing =vlookup(A1&"*",B1:C10,2,true) and got nothing. I want it to return cell C1 498 in cells D1:D3.

Thanks!!

 

[VoG]

Try a fuzzy lookup http://www.mrexcel.com/forum/excel-questions/195635-fuzzy-matching-new-version-plus-explanation.html

 

[rob_ford16]

That looks super complicated and it looks like I would still have to manually verify each record returned the correct value...my file contains over 200,000 records so that could take forever! Is there anyway I could format things a certain way that would help? I tried removing all symbols but still got an error...

 

[marknhopgood]

What does the number 498 represent?
What is your master list?
What are you comparing?

I have an idea as to how to do this, just need a little more info on what you are trying to achieve.