Left Lookup to Return Multiple Values Given 2 Criteria

Hi All,

THis is way out of my league so help would very gratefully appreciated.

On the attached workbook, I have 2 sheets - a DATA sheet with the lookup table and a PLAN sheet where I wish to populate a list of Job Ref given 2 criteria on that sheet - Date and Crew. The formular I require is in E6 to E13 on the Plan sheet given the criteria in cells B2 (date) and B6 (crew). I have pasted in the expected results given the 2 criteria shown which returns 4 jobs.

Also, the data set on the DATA sheet will increase/decrease daily as the sheet is updated.

Hope this makes sense. Thanks.

Capture.JPG