Dynamic lists, overlook spaces

[Kevin McClement]

Good morning all, i've been asked to modify a list i have
for a user. the readers digest version is that i have two
sheets. the second sheet is a list of employees,
depending which unit they are on, it returns a status of
said unit pulled from the first book. the sheet then
conditionally formats a color based on their assigned
units' status, down (green), working (white), or
unavailable (Red). this formula:

=IF(OR(H2=999,H2=111),0,INDEX(STATUS,MATCH(H2,Rig,0)))

looks at the first sheet which tracks the units' status
that they are currently assigned to. i have two named
ranges per sheet:
Sheet 1 Unit status workbook:
1. RigList=OFFSET('Red Deer'!$A$6,0,0,COUNT('Red Deer'!
$A:$A),1)
2. RigStatusList=OFFSET(RigList,0,7)
Sheet 2 Crew list:
1. Rig='Current Rig Report.xls'!RigList
2. RigStatus='Current Rig Report.xls'!RigStatusList

It's the RigList that needs editing. it needs to overlook
blanks in column A so that i can put some space in the
list to define different areas within the company and
have some subtotalling formulas present under each
division.

i have always told my users to make the row height higher
before they go mucking about leaving empty rows etc, in
database type sheets, but if i can fix it this way the
uppity ups will be saited and the crisis averted.

If i can lend any more specifics, please let me know.

TIA.
Kevin McClement