Find list of names in one cell, pasting value of cell that goes next to it in new worksheet

[Looneytn]

I have apx 5500 rows. In column H, have different names (many rows with duplicate names). I want to search for all of the ones with the name "double circle", and paste the cell next to it (from column I) into a different work sheet. What formula would I use?

 

[Reggie74]

What happens if you apply a custom filter on column H ?
If this works you can copy the info in column I to a different sheet ... ??

Let me know ...

I have apx 5500 rows. In column H, have different names (many rows with duplicate names). I want to search for all of the ones with the name "double circle", and paste the cell next to it (from column I) into a different work sheet. What formula would I use?

 

[Looneytn]

No, I wanted to create something a little more repeatable.

Two other answers I received worked

Nesting a find Statement inside an If Statement,

=if(find("Double Circle", H1:H5500,1>0,column I want copied, 0)

or easier for what I really needed

=If("datasheet!$H1="double circle", datasheet!I1,0)

Then I created a macro to delete all rows with Zero