Match or fussy logic

Hi list,
Is there any way to match two cell which are not exactly
same.
for example

A               B
Welldone        Well done
Well done       Well-done
Mango           Mongo


 I need it to consolidate to separately prepared lists.

Any clue? Pl suggest.

Rd, Ratnesh

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

You can use Match with a sorted list with a wildcard.

=Match("AB*",A2:A10,1)

Finds the first row before 'AB'.


Regards
Robert McCurdy
----- Original Message ----- 
From: "Ratnesh Tripathi" <Ratnesh.TripathiRELIANCEADA.COM>
To: <EXCEL-GPEACH.EASE.LSOFT.COM>
Sent: Friday, April 13, 2007 5:50 PM
Subject: Match or fussy logic


Hi list,
Is there any way to match two cell which are not exactly
same.
for example

A               B
Welldone        Well done
Well done       Well-done
Mango           Mongo


 I need it to consolidate to separately prepared lists.

Any clue? Pl suggest.

Rd, Ratnesh

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

You might want to make a select case list with this idea.
Modify to suit
Sub matchlist()
For i = 6 To 16
Select Case Cells(i, "d")
Case "a a", "a-a", "aa": x =
Cells(i, "d")
Case "b a", "b-a", "ba": x =
Cells(i, "d")
Case Else
End Select
If Len(Cells(i, "d")) > 1 And Len(x) > 1
Then _
    Cells(i, "e") = x
Next i
End Sub


Don Guillett
SalesAid Software
dguillett1austin.rr.com
----- Original Message ----- 
From: "Dennis Plyler (ADE)" <Dennis.PlylerARKANSAS.GOV>
To: <EXCEL-GPEACH.EASE.LSOFT.COM>
Sent: Friday, April 13, 2007 7:31 AM
Subject: Re: Match or fussy logic


Received this idea from the listserv last year:

Column A - First List (data start in Row 4)
Column C - Second List (to compare to First List)

=IF((COUNTIF(A:A,C4)>0),"content text from another
field","does not
exist")

HTH

Dennis
 "If you think it's expensive to hire a professional to
do the job, wait
until you hire an amateur."
Red Adair


-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
On
Behalf Of Ratnesh Tripathi
Sent: 13 April 2007 06:51
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Match or fussy logic

Hi list,
Is there any way to match two cell which are not exactly
same.
for example

A               B
Welldone        Well done
Well done       Well-done
Mango           Mongo


 I need it to consolidate to separately prepared lists.

Any clue? Pl suggest.

Rd, Ratnesh

------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G