Matching items that resemble

[Ify]

Moderating my query further to ease the help I need, I need an exce
formular to search for similar items from one sheet to another an
identify the customer no if similar pattern found.
Using a lookup or any other formular where there is a similar nam
found in one sheet to specify the customer no .

Thank you All .

Exemple:

Sheet 1:

No: Customer Name:

105 Freb baker
120 Harry Joseph
115 Craig Juta
135 Alfred keith

Sheet2:

Name : No:

Crag Jut
Fred Baka
Kaith Alf
Josep Har

 

[Frank Kabel]

Hi
have you checked the links provided to you. they would have lead you to
http://www.google.com/groups?selm=8BA%[email protected]
ger.com

and
http://groups.google.com/groups?selm=#dvVeDvgAHA.2080@tkmsftngp04
http://groups.google.com/groups?selm=eRlSt2HKBHA.1592@tkmsftngp04

with some possible solutions