vLookup formula stopped working - maybe too formula too long?

[Metalboy]

This is my formula that now doesn't work having added more to it (see highlighted)

=IF(AND(A3="CS",C3="Yes"),VLOOKUP(B3,Param_Temp_cs_InsYes,2,FALSE),IF(AND(A3="CS",C3="No"),VLOOKUP(B3,Param_Temp_cs_InsNo,2,FALSE),IF(AND(A3="Austenitic",C3="Yes"),VLOOKUP(B3,Param_Temp_ac_InsYes,2,FALSE),IF(AND(A3="Duplex",C3="Yes"),VLOOKUP(B3,Param_Temp_ac_InsYes,2,FALSE),IF(AND(A3="SS",C3="Yes"),VLOOKUP(B3,Param_Temp_ac_InsYes,2,FALSE),IF(AND(A3="Austenitic",C3="No"),VLOOKUP(B3,Param_Temp_ac_InsYes,2,FALSE),IF(AND(A3="Duplex",C3="No"),VLOOKUP(B3,Param_Temp_ac_InsYes,2,FALSE),IF(AND(A3="SS",C3="No"),VLOOKUP(B3,Param_Temp_ac_InsYes,2,FALSE),IF(AND(A3="CS",C3="Yes"),VLOOKUP(B3,Param_Temp_cs_InsYes_MaxRng,2,FALSE))))))))))

The formula worked fine before i added the highlighted vlookup statement. Have I hit a character limit for formula's do you think?

I have both tested the offending formula in isolation and it works fine and also rearranged the formula and placed the statement at the beginning after which that part of the formula works fine but one of the other statements does not. So thats why I think i've hit a character limit perhaps.

Any help would be greatly appreciated.

 

[Metalboy]

The bit " AND(A3="CS",C3="Yes") " is already in the first IF statement:

=IF(AND(A3="CS",C3="Yes"),VLOOKUP(B3,cs_IY,2,FALSE),IF(AND(A3="CS",C3="No"),VLOOKUP(B3,cs_IN,2,FALSE),IF(AND(A3="Austenitic",C3="Yes"),VLOOKUP(B3,ac_IY,2,FALSE),IF(AND(A3="Duplex",C3="Yes"),VLOOKUP(B3,ac_IY,2,FALSE),IF(AND(A3="SS",C3="Yes"),VLOOKUP(B3,ac_IY,2,FALSE),IF(AND(A3="Austenitic",C3="No"),VLOOKUP(B3,ac_IY,2,FALSE),IF(AND(A3="Duplex",C3="No"),VLOOKUP(B3,ac_IY,2,FALSE),IF(AND(A3="SS",C3="No"),VLOOKUP(B3,ac_IY,2,FALSE),IF(AND(A3="CS",C3="Yes"),VLOOKUP(B3,cs_IYMR,2,FALSE))))))))))

If it returns TRUE in the first instance, the formula should return the result of VLOOKUP(B3,cs_IY,2,FALSE)
If it is FALSE in the first instance, it'll also be false in the second and the formula result will be "FALSE" because the ELSE part of the last IF function is missing.

Thanks so much, that was my problem! I couldn't see the wood for the trees. Really appreciate you all taking the time to help out.