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

Looneytn

New Member
Joined
Oct 1, 2014
Messages
3
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?
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Reggie74

Board Regular
Joined
Sep 26, 2014
Messages
51
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 ...:confused:

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

New Member
Joined
Oct 1, 2014
Messages
3
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,311
Members
409,862
Latest member
lbisacca
Top