multiple if functions with index, match function.

Hey,

I keep getting an value error when using the below formula. Can anyone shed some light interms of why i am getting the value error?

Please Login or Register  to view this content.

IF(AU5="17 Rate",IFERROR(INDEX('REV 17 RATE'!$B$7:$IW$280,MATCH(A10,'REV 17 RATE'!$A$7:$A$280,0),MATCH($I$1&$I$2&$I$3,'REV 17 RATE'!$B$3:$AAK$3,0)),"Not Found")/1000000),IF(AU5="Act Rate",IFERROR(INDEX('REV @ACT Rate'!$B$7:$IW$280,MATCH(A10,'REV @ACT Rate'!$A$7:$A$280,0),MATCH($I$4&$I$2&$I$3,'REV @ACT Rate'!$B$3:$AAK$3,0)),"Not Found"))/1000000

Please Login or Register  to view this content.

That did the trick but now it's not dividing by 1000000 (1M) so I removed the 1M next to "Not Found" then I included the 1M towards the end of the formula and it worked. Thanks for your Help!!!