How to match text exactly and carry with * on the end of the text.

[jerung3000]

Hi all,

I need help on this solve this problem

Excel Prob.png

My function was like this :

=IFERROR(IF(MATCH($A2,$B$2:$B$11,0),"O"),"X")

below is the Data and I need data column A can be found in the column B even it not in the same row

Column A Column B
MIQ* MIA
MI* MIQA
MIA* MII*
MIAR* DELEUM*
MAGNI* MAGNI*
YOCB YOCB
LII* LIIHEN*
FIAMMA* FIAMMA*
DMINAN* HOMERIZ
HOMERIZ DOMIAN*

Please somebody help me.

Thanks

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[davsth]

An attachment would be much better, but if the * are always at the end, this is in inelegant solution hopefully

=IFERROR(IF(MATCH(IF(RIGHT(A2)="*",LEFT(A2,LEN(A2)-1)&"~*",A2),B2:B11,0),"O"),"X")

or

=IFERROR(IF(MATCH(LEFT(A2,LEN(A2)-1)&"~"&RIGHT(A2,1),B2:B4,0),"O"),"X")

[jerung3000]

It works.. Thanks a lot davsth..