Spreadsheet: 37226d1235158003-how-do-i-populate-a-cell-with-a-value-from-one-of-three-columns-task_codes-version-3-
Sheet: Sheet1

 | VS-001_Single_Camera_(HD) |  |  |  |  |  |  | a | b | c
 |  | VS-001A_Prepare_Shooting_Package |  |  | VS - Video Shoots
 |  | VS-001B_Shoot_Event |  |  |  | VS-001_Single_Camera_(HD)
 |  | VS-001C_Dump_Footage |  |  |  |  | VS-001A_Prepare_Shooting_Package | 1 | 2 | 3
 |  |  |  |  |  |  | VS-001B_Shoot_Event | 4 | 5 | 6
 |  |  |  |  |  |  | VS-001C_Dump_Footage | 7 | 8 | 9
 |  |  |  |  |  | VS-002_Two_Camera_(HD)
 |  |  |  |  |  |  | VS-002A_Prepare_Shooting_Package
 |  |  |  |  |  |  | VS-002B_Shoot_Event
 |  |  |  |  |  |  | VS-002C_Dump_Footage
 | DA_001 Title Page |  |  |  |  | VS-003_Multi_Camera_(HD)
 |  | DA_001A Set up DVD |  |  |  |  | VS-003A_Prepare_Shooting_Package
 |  | DA_001B Burn DVD Master |  |  |  |  | VS-003B_Shoot_Event
 |  | DA_001C Check DVD Master |  |  |  |  | VS-003C_Dump_Footage
 |  | DA_001D [NAME] |  |  |  | VS-004_Single_Camera_(SD)
 |  | DA_001E Create DVD Label |  |  |  |  | VS-004A_Prepare_Shooting_Package
 |  | DA_001F Create Discribe Job |  |  |  |  | VS-004B_Shoot_Event
 |  |  |  |  |  |  | VS-004C_Capture_Footage
 |  |  |  |  |  | VS-005_Two_Camera_(SD)
 |  |  |  |  |  |  | VS-005A_Prepare_Shooting_Package
 | VS-001_Single_Camera_(HD) |  |  |  |  |  | VS-005B_Shoot_Event
 |  | VS-001A_Prepare_Shooting_Package |  |  |  |  | VS-005C_Capture_Footage
 |  | VS-001B_Shoot_Event |  |  |  | VS-006_Multi_Camera_(SD)
 |  | VS-001C_Dump_Footage |  |  |  |  | VS-006A_Prepare_Shooting_Package
 |  |  |  |  |  |  | VS-006B_Shoot_Event
 |  |  |  |  |  |  | VS-006C_Capture_Footage
 |  |  |  |  | PS - Photo Shoots
 |  |  |  |  |  | PS_001 Single Camera
 |  |  |  |  |  | PS_002 Two Camera
 |  |  |  |  |  | PS_003 Multi Camera
 | VE_001 Edge Trim
 |  | VE_001A Edit Footage |  |  | VE - Video Edits
 |  | VE_001B [NAME] |  |  |  | VE_001 Edge Trim
 |  | VE_001C Edit Audio |  |  |  |  | VE_001A Edit Footage
 |  | VE_001D Add Chapter Markers |  |  |  |  | VE_001B [NAME]
 |  | VE_001E Compress Footage |  |  |  |  | VE_001C Edit Audio
 |  |  |  |  |  |  | VE_001D Add Chapter Markers
 |  |  |  |  |  |  | VE_001E Compress Footage
 |  |  |  |  |  | VE_002 Multi-Clip
 |  |  |  |  |  | VE_003 Fast Edit
 | DA_001 Title Page |  |  |  |  | VE_004 Full Edit
 |  | DA_001A Set up DVD |  |  |  | VE_005 Match Audio
 |  | DA_001B Burn DVD Master
 |  | DA_001C Check DVD Master |  |  | DA - Disc Authoring
 |  | DA_001D [NAME] |  |  |  | DA_001 Title Page
 |  | DA_001E Create DVD Label |  |  |  |  | DA_001A Set up DVD
 |  | DA_001F Create Discribe Job |  |  |  |  | DA_001B Burn DVD Master
 |  |  |  |  |  |  | DA_001C Check DVD Master
 |  |  |  |  |  |  | DA_001D [NAME]
 |  |  |  |  |  |  | DA_001E Create DVD Label
 |  |  |  |  |  |  | DA_001F Create Discribe Job
 |  |  |  |  |  | DA_002 Title Page + Menus
 |  |  |  |  |  | DA_003 Title Page (Motion)
 |  |  |  |  |  | DA_004 Title Page + Menus (Motion)
 |  |  |  |  | GD - Graphic Design
 |  |  |  |  |  | GD_001 Crop and Color
 |  |  |  |  |  | GD_002 Compositing
 |  |  |  |  |  | GD_003 DVD/CD Sleeve
 |  |  |  |  |  | GD_004 DVD/CD Label
 |  |  |  |  |  | GD_005 Print Layout
 |  |  |  |  | VD - video design
 |  |  |  |  | WD - web design
 |  |  |  |  | FD - flash design
 |  |  |  |  | SD - sound design
 |  |  |  |  | vc - video conversion
 |  |  |  |  | DD - disc duplication
 |  |  |  |  |  | DD_001 Small Run B&W
 |  |  |  |  |  |  | DD_001A [NAME]
 |  |  |  |  |  |  | DD_001B [NAME]
 |  |  |  |  |  | DD_002 Large Run B&W
 |  |  |  |  |  |  | DD_002A [NAME]
 |  |  |  |  |  |  | DD_002B Package Discs
 |  |  |  |  |  | DD_001 Small Run Color
 |  |  |  |  |  |  | DD_003A [NAME]
 |  |  |  |  |  |  | DD_003B Package Discs
 |  |  |  |  |  | DD_002 Large Run Color
 |  |  |  |  |  |  | DD_004A [NAME]
 |  |  |  |  |  |  | DD_004B [NAME]
 |  |  |  |  | wv - web video
 |  |  |  |  | ls - live support
 |  |  |  |  | ws - web support
 |  |  |  |  | sh - shipping & handling
 |  |  |  |  | ad - administration
 |  |  |  |  | ar - archiving
 |  |  |  |  | qc - quality control
 |  |  |  |  | os - online sales
 |  |  |  |  | ER - Equipment Rental
 |  |  |  |  | SR - Studio Rental