I have to columns in excel (A and B) as follows:

with text phrases inside. I want to check if a the the phrases of B exists in the A column. If exists, then to print the phrase, if not to print blank cell. The final result must be

How can i do that in Excel?

CodePudding user response：

Use XLOOKUP() like-

=XLOOKUP(B1:B6,A1:A6,A1:A6,"",0)