I have the following formula:

=IF(ISNA(VLOOKUP($C8,INDIRECT(VLOOKUP($B8,PhaseLoo kup,$BM$9*2,0)),2,0)),"",IF(ISERROR(LEFT(C8,FIND("--",C8,10)-2)),HYPERLINK("#"&CELL("address",INDEX('Activity
Desc.'!$E$2:$E$43,MATCH(C8,'Activity
Desc.'!$A$2:$A$43,0),1)),"Info"),HYPERLINK("#"&CEL L("address",INDEX('Activity
Desc.'!$E$2:$E$43,MATCH(LEFT(C8,FIND("--",C8,10)-2),'Activity
Desc.'!$A$2:$A$43,0),1)),"Info")))

As soon as I add one more IF statement to the front of the formula:

=IF(ISBLANK($B8),"",IF(ISNA(VLOOKUP($C8,INDIRECT(V LOOKUP($B8,PhaseLookup,$BM$9*2,0)),2,0)),"",IF(ISE RROR(LEFT(C8,FIND("--",C8,10)-2)),HYPERLINK("#"&CELL("address",INDEX('Activity
Desc.'!$E$2:$E$43,MATCH(C8,'Activity
Desc.'!$A$2:$A$43,0),1)),"Info"),HYPERLINK("#"&CEL L("address",INDEX('Activity
Desc.'!$E$2:$E$43,MATCH(LEFT(C8,FIND("--",C8,10)-2),'Activity
Desc.'!$A$2:$A$43,0),1)),"Info"))))

I get an error (and the FIND function is highlighted)! Can anyone tell me
why? I thought Excel allows up to 7 nested IF statements. My formula has
only 3.
Thanks for the help,
Bob