Text searching within a cell, returning the nearest value.

Hello experts,

Need an help in writing a fuction or VBA code for the text in returns the similar (or nearly value match) value of the text.

Example
refer the customer A sheet

and other sheet called Master A sheet

I want to find string search (from Customer A sheet) which will match the nearest string match(in Master A Sheet) returning the customer number.?

I used vlookup but it seems to returning the extact content match not the nearest ... http://www.excelforum.com/images/icons/icon9.png

pls help me and advise me the right function name or VBA where i can do for similar lakhs of records?

waiting for your reply