Is there a formula I could put in all the cells below cell A3 where it would populate the client names of the person selected? For example, if I selected "Chelsea", I would like it to list Baptist North in Cells A4, Baptist South in cell A5, Coosa in cell A6, and so on and so forth for all the hosiptals Chelsea has. Same thing for Melissa or Molly. If Mellisa is selected, I would list for it to list Bacon in Cell A4, and so on and so forth.

Reapply Advanced Columns Fill Duplica Properties Get From From From Table/ Recent Existing Refresh Data Text/CSV web Range Sources Connections All- Sort Filter Text to Flash Remo Edit Links Get & Transform Data Queries & Connections Sort & Filter A3 4 Chelsea 5 Mol 6 Melissa Molly Eliza Coffee Memorial Hospital Liberty Regional Medical Center Northside Hospital Optim Medical Center - Jenkins Optim Medical Center - Screven Optim Medical Center - Tattnall Phoebe Sumter Medical Center Putnam General Hospital Russell Medical Center Chelsea Baptist North Bacon Baptist South Burke Melissa Chatuge East Alabama Crisp Hardin Jack Hughston Dekalb Medical North Decatur Lanier Marshall Riverview Union Medical Southern Regional Medical Center Tift Regional Medical Center Dekalb Medical 10 Dodge County Hospital Houston Medical Center Hughston Clinic 12 13 14 15 16 17 18 19 Union General West Georgia Medical Center Wayne Memorial Hospital 21