CODEWITHSUNDEEP
excelif-statementexcel-formulamatch
nickolakis
nickolakis

Reputation: 621

If and Match statements in an excel formula

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

enter image description here

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

enter image description here

How can i do that in Excel?

Upvotes: 0

Views: 76

Answers (1)

Harun24hr
Harun24hr

Reputation: 36750

Use XLOOKUP() like-

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

enter image description here

Upvotes: 1

Related Questions