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