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