3 Nested IF INDEX MATCH

Hi All,

I have the following formula:

=IF(L4=32,INDEX('Test 1'!B9:H258,MATCH(Test 2!M4,'Test 1'!A9:A258,0),MATCH(Test 2!N4,'Test 1'!B8:H8)+ISNA(MATCH(Test 2!N4,'Test 1'!B8:H8,0))))
,IF(L4=64,INDEX('Test 1'!J9:P258,MATCH(Test 2!M4,'Test 1'!I9:I258,0),MATCH(Test 2!N4,'Test 1'!J8:P8)+ISNA(MATCH(Test 2!N4,'Test 1'!J8:P8,0))))
,IF(L4=100,INDEX('Test 1'!AA9:AH56,MATCH(Test 2!M4,'Test 1'!Z9:Z56,0),MATCH(Test 2!N4,'Test 1'!AA8:AH8)+ISNA(MATCH(Test 2!N4,'Test 1'!AA8:AH8,0))))


I have split the formula up to show the 3 If statements, if i miss out the 3rd statement i get the correct value for "32" or "64".
When i add the 3rd statement and input "100" i get the #VALUE! error.

I cant work out why as it all looks ok to me....

Please Help...

Craig

Did you have your sample workbook, maybe better try to upload it at the forum to review the problem....

Cheers

Perfect.

Thankyou Very Much.