Match and return

[Tammyx423]

Hey guys, i have a question but i can't find the answer.

I have 4 columns here:


101 101 apple beer
102 102 orange coke
102 tennis pen
105 peper tea
106 juice cookies

and i need to write a funtion to match column A and B, and if it match, return everything/ rows

So, the result should be:

101 apple beer
102 orange coke
102 tennis pen

[Dav]

why is tennis pen a match?

Regards

Dav

[sglife]

for the column ABCD, row 1

E1=IF(EXACT(A1,B1),CONCATENATE(B1," ",C1," ",D1),"")