Matching cells in which only certain strings of text are equal [Closed]

Report

James The Rock - Aug 4, 2015 at 05:16 AM

Hi everyone,

I'm trying to find a way to use excel to match two columns of information.

The problem is that those two columns do not contain the exact same information.

We can have: Cat - Dog - Pet in one cell of one of the columns and Dog, House, Tree in the next column.

For the purpose of my work, these two are a match but I don't know how to use excel to tell me that they match.

Any ideas?

Matching cells in which only certain strings of text are equal
Excel match cells with similar text - How-To - Excel
Matching cells but exclude blanks ✓ - Forum - Excel
Match cells in excel with all characters same except one ✓ - Forum - Excel
Excel VBA - Find and Expand matching cell entries ✓ - Forum - Excel
Any part of string in cell matches part of string in another ✓ - Forum - Excel

Matching cells in which only certain strings of text are equal [Closed]

Your reply

Subscribe To Our Newsletter!