Excel Help needed: comparing cell contentsClosed

Question

Hi all,

Is there a way to compare the contents of a cell with a different cell using TRUE/FALSE results?

For instance, 
cell A1 contains: Jr3 
comparing with 
cell B1 contains: Jr3

cell C1 (the result cell) will show up TRUE

now what if I want to match the content of B1 with cell A1 which contains more than one value in it?
For instance,
cell A1:  Jr3, Jr4 
comparing with 
cell B1 containing Jr3

cell C1 should show up TRUE (since cell A1 does have Jr3 as its value separated by a comma)

Please Help. Thx

mysterry60 · Answer

Dear Vtech, 

Please get the problem solved through the help of the following Kioskea FAQ article. 

https://ccm.net/faq/4698-excel-comparing-cell-a1-to-entire-a-column-in-sheet-2

Thanks in advance.

Trowa · Answer

Hi Vtech,

In this case you could use the following formula:
=IF(ISERROR(FIND(B1;A1)),"False","True")

Hopefully this helps you onward solving your query.

Best regards,
Trowa

Excel Help needed: comparing cell contents

2 responses

Similar discussions

Subscribe To Our Newsletter!