Your profile says 2007, which does not have the 7-level restriction...and that restriction would not even let you enter, if it was a factor.\


Also, I dont see why it needs to be array-entered?

Are you trying to save as 2003 (.xls)?

Because you are using 2007, you can simplify that formula to this...

=IFerrorA(VLOOKUP(Master!A2,RockSlopes!$AE$4:$AI$253,4,FALSE),
IFerror(VLOOKUP(Master!A2,'2ndEastMains'!$AE$4:$AK$250,4,FALSE),
IFerror(VLOOKUP(Master!A2,'1stEastMains'!$AE$4:$AK$250,4,FALSE),
Iferror(VLOOKUP(Master!A2,'1stSouthMains'!$AE$4:$AK$250,4,FALSE),
IFerror(VLOOKUP(Master!A2,SouthBreakout!$AE$4:$AK$250,4,FALSE),
IFerror(VLOOKUP(Master!A2,WestBreakout!$AE$4:$AK$250,4,FALSE),
IFerror(VLOOKUP(Master!A2,Sump!$AE$4:$AI$250,4,FALSE),"")
(I think I got the () and , right)