Hi

I have the following list in columns a & b if i put "Kinsley" in c1 how do i then lookup all the kinsley entries in column a and return their entries from column b populating c2 and downwards?

Thanks for any help offered


Belle 2. Midtown Act
Belle 1. Manifold Liz
Belle 3. Boldylocks
Belle 4. Above All Else
Belle 3. Thistlecrack
Belle 6. Castlegore Paris
Belle 2. Holycross Sky
Belle 1. Chopchop Nellie
Belle 5. Ballymac Opal
Belle 1. Sienna Noir
Belle 5. Mill Cigar
Belle 4. Goody Gumdrops
Central 1. Boozed Flash
Central 4. Small And Dainty
Central 3. Killuran Lilly
Central 3. Lenson Wilson
Henlow 2. Bright Elena
Henlow 2. Westmead Angelic
Henlow 2. Savana Richy
Henlow 4. Savana Jo Jo
Henlow 5. Clarence Seadog
Hove 1. Abbodabbo Dasher
Hove 1. Babyface Violet
Hove 4. Cloheena Hooley
Hove 5. Nothing Special
Hove 6. Mineola Duke
Hove 4. Chopchop Arthur
Kinsley 4. Nearly Perfect
Kinsley 3. Slaneyside Tejay
Kinsley 4. Colmyard Molly
Kinsley 3. Barefoot Giada
Kinsley 3. Wishaw Rebel
Kinsley 5. Tarmons Holly
Kinsley 5. Shanty Scorpion
Kinsley 5. Miss Sprite
Kinsley 4. Run China Tip
Kinsley 3. Slaneyside Adele
Kinsley 6. Almoradi Mai