On Fri, 25 May 2007 05:44:00 -0700, pshepard
wrote:

Hi John,

The Search function allows "*" (asterisk) as a wild card. In order to make
the numbers in your example, the value in B2 is the first 5 characters,
substituting 0 with "*":

B1: 10571234
B2: 1*571
B3:B7 =IF(ISERROR(SEARCH(B$2,A3))=TRUE,"","Fuzzy Match")
A3:10571453
A4:1571234
A5:1057123
A6:10571234
A7:10571243

Let me know if this works for you.

Thanks,
Peggy

Thanks. I'll give this a try.

John