View Single Post
 
Old 03-06-2017, 02:09 PM
stockers stockers is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Mar 2013
Posts: 4
stockers is on a distinguished road
Default Returning value based on multiple crtiteria

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.
Reply With Quote