G'day

I have a Workbook with multiple sheets where i'm trying to return the name of a person filling a particular role based on the date and the role.

For example.
Sheet: Structure Chart
U9= 'formula'
U8= Incident Controller (Role)
H5= Date



Sheet: Sheet 1
B2:AF2= Row of dates
A3:A38= Role
B3:AF38= name of people filling roles on a particular day.

What I want to happen is that the formula in U9 returns the name of the Incident Controller for the date in H5. The name can be found in Sheet 1 going by the role (incident controller) and the date.

Hope this makes sense.