I need a way to compare one cell to the adjacent cells and/or a range o
cells... wherein the cells would not be exactly matched strings o
text.

Example:

A1 - Bags of Apples
A2 - Bags of Oranges
-or-
A1 - C17 2004 Envelop
A2 - C19 2003 Envelopes

In these examples the formula would provide some indicator of note
like "Match" or something.

Is there anyway to do this with a function or macro

--
Message posted from http://www.ExcelForum.com