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

"Max" wrote:

The formula is essentially an index/match with an ISNA error trap to return
blanks: "" for any unmatched cases, viz.:
=IF(ISNA(MATCH(...)),"",INDEX(...,MATCH(...)))

The OFFSET part of it within the MATCH basically grabs the correct col array
in each team's roster sheet, via matching the dates in B3:F3 against the
dates in the team's roster sheet (eg in C3:G3 in sheet: Team A Roster). The
col array returned by the OFFSET is then used as the reference array in the
MATCH, to match the individual names in A10:A13. The return from MATCH is
then used to return the corresponding value within the indexed range.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MikeR-Oz" wrote:
Max, Would it be too much trouble to write in plain english what each part of
the command/formulae is doing? I do not even know what ISNA is?

If not no probs I will keep at it.
Cheers
and thanks again
Mike