Both of the earlier 2 expressions could be merged into one,
illustrated in this sample:
http://www.freefilehosting.net/download/3gl3m
Roster_Automation_2.xls

In Roster hours,
In B10:
=IF(ISNA(MATCH($A10,OFFSET('Team A Roster'!$B$4:$B$7,,MATCH(B$3,'Team A
Roster'!$C$3:$G$3,0)),0)),IF(ISNA(MATCH($A10,OFFSE T('Team B
Roster'!$B$5:$B$8,,MATCH(B$3,'Team B Roster'!$C$4:$G$4,0)),0)),"",INDEX('Line
Hours accumulation'!$B$4:$B$7,MATCH($A10,OFFSET('Team B
Roster'!$B$5:$B$8,,MATCH(B$3,'Team B Roster'!$C$4:$G$4,0)),0))),INDEX('Line
Hours accumulation'!$B$4:$B$7,MATCH($A10,OFFSET('Team A
Roster'!$B$4:$B$7,,MATCH(B$3,'Team A Roster'!$C$3:$G$3,0)),0)))
Copy B10 across/fill down to F17 to populate
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MikeR-Oz" wrote:
HI Max, The names that are assigned to Team A or Team B roster can change .
Is it possible for the formulae to lokk across bothe rosters for the staff
names to populate the Roster hours? Rather than running the formulae across a
specific set can it be run across both?
Mike