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

[fasihuddin]

Hi,

Column A	Column B
I go market	I am going market
I go hospital
I go park	I am going park
I go market
I go office
I go park

<tbody>
</tbody>

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!