If Particular Text is in one cell then produce the information from another

[ajk125]

Hi All, Hope someone can help.

If the word Dog is in B1 in Sheet1
Then
I want the information in A1 and C1 to be produced in another sheet (sheet2)

If possible i would like it to search the whole of Column B and everytime it locates the word "Dog" it will take the data from columns A1 and C1 and produce it in Sheet 2.

Hope this makes sense

Thanks in advance

Anthony

[azumi]

Yes it does possible, but maybe could be great help if you upload your sample workbook and explain the desired results.
To attach your file, click "Go Advanced" button and then find paperclip button to attach the file.

[ajk125]

Please find attached

[azumi]

I see your file, and you have duplicates there, like Dog, DOG, DOg, and you have on your sheet 2 "Dog", need to clarify the results that you need to extract.

[azumi]

Ok please see the file attach, maybe something like this?