Given your data, the following formulas will generate a match:

=a1=b1
=right(a2,5)=right(b2,5)
no match in row 3
=substitute(a4,"/"," ")=b4

However, if other date have different similarities, you may find if more
efficient to write a macro to toss out the extraneous stuff, so you end up
with exact matches.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Jane" wrote in message
...
colu. 1 contains:

1001
vendor 43980
1001/1180/90 CAT 8
1001/1180/90/8

col. 2 contains:
1001
SD3 vendor number 43980
PO 45609
1001 1180 90 8

I need to match these 2 columns IF the values are the same, regardless of
text.

Any suggestions?