anthonyexcel
Active Member
- Joined
- Jun 10, 2011
- Messages
- 258
- Office Version
- 365
- Platform
- Windows
I have about 150000 rows of data like below. I would like to look up a bold value. For instance if I have New York in cell D1, I want to bring back all of the values underneath New York so it would return
<tbody>
</tbody>Here is what the data looks like below:
<tbody>
</tbody>
Jay |
Fred |
Mary |
Ted |
Sam |
<tbody>
</tbody>
Connecticut |
Steve |
Ray |
Bob |
Jimmy |
New York |
Jay |
Fred |
Mary |
Ted |
Sam |
Maine |
Sonny |
Johnny |
Angelo |
Salvatore |
Gino |
California |
Gus |
Dave |
Ken |
Ralph |
George |
Manny |
<tbody>
</tbody>