Spreadsheet: 126548d1319740329-hierarchy-lookup-and-auto-populate-directory-example
Sheet: Directory

Director | AD | Staffing Mgr
[NAME] | [NAME] | Clutts, Zane
[NAME] | [NAME] | [NAME], [NAME]
[NAME] | [NAME] | Crescenti, [NAME]
[NAME] | [NAME] | Mertes, Fred
[NAME] | [NAME] | Presley, Sandra
[NAME] | [NAME] | Vendramin, [NAME]
[NAME] | [NAME] | Bowley, Megan
[NAME] | [NAME] | Deuser, [NAME]
[NAME] | [NAME] | Grimaldo, Mario
[NAME] | [NAME] | Hart, [NAME]
[NAME] | [NAME] | [NAME], [NAME]
[NAME] | [NAME] | Valdez, Dianne
[NAME] | [NAME] | [NAME], Stuart
[NAME] | [NAME] | Drayer, [NAME]
[NAME] | [NAME] | Flatt, Maria
[NAME] | [NAME] | Nix, Karana
[NAME] | [NAME] | Sessions, Piper
[NAME] | [NAME] | Stiehr, [NAME]
[NAME] | Bullwinkle | Benson, [NAME]
[NAME] | Bullwinkle | Brooks, Anwar
[NAME] | Bullwinkle | [NAME], [NAME]
[NAME] | Bullwinkle | [NAME], [NAME]
[NAME] | Bullwinkle | Cowart, Grady
[NAME] | Bullwinkle | Escobedo, Sergio
[NAME] | Bullwinkle | Kirkland, [NAME]
[NAME] | Bullwinkle | Kornegay, [NAME]
[NAME] | Bullwinkle | Lenhart, Beverly
[NAME] | Bullwinkle | McDavid, Sherry
[NAME] | Bullwinkle | Pope, Candice
Frankenstein | [NAME] | Chraska, [NAME]
Frankenstein | [NAME] | Cossey, Victoria
Frankenstein | [NAME] | Davila, Oma
Frankenstein | [NAME] | Fragosa, Dolly
Frankenstein | [NAME] | [NAME], [NAME]
Frankenstein | [NAME] | Jenkins, [NAME]
Frankenstein | [NAME] | [NAME], Becky
Frankenstein | [NAME] | Moore, Pamelia
Frankenstein | [NAME] | Contreras, Christie
Frankenstein | [NAME] | Magpusao, Angelica
Frankenstein | [NAME] | Mizera, [NAME]
Frankenstein | [NAME] | Sakamoto, Rebecca
Frankenstein | [NAME] | Smith, [NAME]
Frankenstein | [NAME] | Sugawara, Charlene
Frankenstein | [NAME] | Thompson, Carol
Frankenstein | Elmer Fudd | [NAME], [NAME]
Frankenstein | Elmer Fudd | Bell, [NAME]
Frankenstein | Elmer Fudd | Bradford, [NAME]
Frankenstein | Elmer Fudd | [NAME], [NAME]
Frankenstein | Elmer Fudd | Kasprzak, Gregory
Frankenstein | Elmer Fudd | [NAME], Rachel
Frankenstein | Elmer Fudd | Scott, [NAME]
Frankenstein | Elmer Fudd | Shaw, [NAME]
Frankenstein | [NAME] | [NAME], [NAME]
Frankenstein | [NAME] | Hebert, Lauri
Frankenstein | [NAME] | Langston, [NAME]
Frankenstein | [NAME] | Wolbach, [NAME]
Frankenstein | Porky Pig | Driver, Natasha
Frankenstein | Porky Pig | [NAME], Sheryl
Frankenstein | Porky Pig | [NAME], [NAME]
Frankenstein | Porky Pig | Robinson, Kimberly
Frankenstein | Porky Pig | Sligh Palmer, [NAME]
Frankenstein | Porky Pig | Warden, [NAME]
Frankenstein | Porky Pig | [NAME], [NAME]
Frankenstein | Loaned | [NAME], Evette
Frankenstein | Loaned | Clark, Sharron
[NAME] | Loaned | Copeland, Lebrentha
[NAME] | Loaned | Degrant, [NAME]
[NAME] | Loaned | [NAME], [NAME]
[NAME] | Loaned | Jones, [NAME]
[NAME] | Loaned | [NAME], [NAME]
[NAME] | Loaned | Lopez-Monterroso, Mayra
[NAME] | Loaned | Pearson, Janice
[NAME] | Loaned | Wimpie, [NAME]
[NAME] | [NAME] | Banister, Therese
[NAME] | [NAME] | Bess, [NAME]
[NAME] | [NAME] | [NAME], Crystal
[NAME] | [NAME] | Charles, Cynthia
[NAME] | [NAME] | Cimino, [NAME]
[NAME] | [NAME] | [NAME], [NAME]
[NAME] | [NAME] | [NAME], [NAME]
[NAME] | [NAME] | [NAME], [NAME]
[NAME] | [NAME] | [NAME], [NAME]
[NAME] | [NAME] | Repech, [NAME]
[NAME] | [NAME] | Trampe, [NAME]
[NAME] | Sad Sack | [NAME], [NAME]
[NAME] | Sad Sack | [NAME], [NAME]
[NAME] | Sad Sack | Deubler, [NAME]
[NAME] | Sad Sack | Norton, Stephanie
[NAME] | Sad Sack | Ridgeway, [NAME]
[NAME] | Sad Sack | Riley, [NAME]
[NAME] | Sad Sack | Rizer-Pool, [NAME]
[NAME] | Sad Sack | Smith, [NAME]
[NAME] | Sad Sack | [NAME], [NAME]
[NAME] | Sad Sack | Thompson, [NAME]
[NAME] | Sad Sack | [NAME], Weda
[NAME] | Richie Rich | Angles, Cyteria
[NAME] | Richie Rich | [NAME], [NAME]
[NAME] | Richie Rich | [NAME], [NAME]
[NAME] | Richie Rich | Mellina, [NAME]
[NAME] | Richie Rich | Simmons, Deb
[NAME] | Richie Rich | Staton, [NAME]
[NAME] | Richie Rich | [NAME], [NAME]
[NAME] | Richie Rich | [NAME], Jeanne
[NAME] | Richie Rich | Worley, [NAME]
[NAME] | Scooby Doo | Clark, Virginia
[NAME] | Scooby Doo | [NAME], [NAME]
[NAME] | Scooby Doo | [NAME], [NAME]
[NAME] | Scooby Doo | Harper, [NAME]
[NAME] | Scooby Doo | [NAME], [NAME]
[NAME] | Scooby Doo | [NAME], [NAME]
[NAME] | Scooby Doo | [NAME], Shani