matching of two list

[paradise2sr]

Hi,

I have two lists in Column B & Column C.On matching D2 & D3 it is prompting FALSE.

How can I match this so that TRUE can be displayed instead of FALSE incorporating differences in formula.

Thanx in anticipation as usual.

[oeldere]

You have to add, what the problem causes.

One of the problems is ;

Select range C1:C3

CTRL + H => find ; => replace by (leave blanc) => replace all.


Edit

The second problem is the leading spaces in your text.

Use the formula trim on of all data of the sheet.

After that the problems are solved in this question.

[paradise2sr]

Without using find and replace ,how it can be solved as I have problem in using find and replace.

[oeldere]

D2 =replace(B2,search(";",B2,1),1,"")

for the second row (b3) I have no solution at this moment.
It will something be with REPT

[oeldere]

Maybe it is a better idea to use data validations for column D to prefent unaccepted input.

[Bo_Ry]

Please try at D2
=TRIM(B2)=TRIM(SUBSTITUTE(C2,";",))

[paradise2sr]

Please try at D2
=TRIM(B2)=TRIM(SUBSTITUTE(C2,";",))

Thanx a lot 😊 this works very fine

[oeldere]

@ paradise2sr

Please also reply on my solution in #5.

[paradise2sr]

I have not tested post#4&5 as I was expecting a single formula which post #6 was successfully worked.

Thanx all of for your kind efforts.