Lookups Match Index??

[myheadhurts]

I am working on a quite complex 5 team, 9 operator continuous shift
system using Excel 2002.

I have a sheet which contains 5 tables which are duplicating
information from 5 other sheets. Each table (9 cols / 366 rows) has a
row which corresponds to the day shift on the same date,
e.g. B4:J4, U4:AC4, AN4:AV4, BG4:BO4, & BZ:CH
only 1 cell out of the 5 ranges has an entry (could be any), all the
other cells are empty (although they contain formulas).
I am trying to create a single column of this entry. This will tell me
out of the 45 opertors who is on shift on each day.

I've been struggling with this for a couple of days, hope someone can
help

I've tried to attach a small sample

Book1.zip

myheadhurts

[NBVC]

Try this in AN3:

Please Login or Register  to view this content.

and this in AO3:

Please Login or Register  to view this content.

copied down.

Note: You can add to the formulas to get involve more data

[myheadhurts]

Brilliant...many thanks

works perfect, I've expanded to include all 5 tables and it's doing just what I needed

thanks again

myheadhurts