Match Data from different cells of same column and if matched return data from corresponding cell.

[fasihuddin]

Hi,


[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]I go market[/TD]
[TD]I am going market[/TD]
[/TR]
[TR]
[TD]I go hospital[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I go park[/TD]
[TD]I am going park[/TD]
[/TR]
[TR]
[TD]I go market[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I go office[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I go park[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want to know a formula to pick data in cell B2 and B4 under cell B5 and B6 since A2=A5 and A4=A6 respectively.

Appreciate if anyone can quickly help.

 

[oldbrewer]

not clear - are you looking for duplications in column A that have either "market" or "park" in them ?

 

[bhos123]

B5=iferror(Vlookup(A5,A$2:B4,2,0),"") and drag down.

 

[fasihuddin]

Just to clarify - I have a data in cell A2 "I go market" and in front of it, in cell B2, I have "I am going market". Now I want B2 data automatically appear in coming cells if its corresponding Ath cell have the same data as in A2. I hope its clear.

 

[fasihuddin]

Thanks fort posting the formula. I have tried it but it's not working, the only result I am getting is a blank cell. Even blank cells are resultant where the data should have been picked. Thanks.

 

[bhos123]

it's working perfectly for me. can you copy A2 to A5 and check the results. may you have extra blanks.

 

[fasihuddin]

It's working now. Thanks very much for the help.

Have a good day ahead.

 

[bhos123]

you are welcome!