IF Statement returning #Value; not sure why?

[Doug Jefferson]

=IF($AE2,"CHRY"), IF($E2="XX",'All BBK Age'!$A$1, VLOOKUP($H2,$AK:$AL,2,FALSE) + M2 - 1), IF($E2="XX",'All BBK Age'!$A$1,VLOOKUP($G2,$AK:$AL,2,FALSE)+I2-1)

My formula above is returning the following #Value in the cell; this is the result of Excels "fix" to my formula.

All of the cells noted in the formulas have values populated in them.

I think I have something missing in my formula but i am not seeing it. Any assistance would be appreciated.

Thank you.

Doug

 

[Titian]

Is it that =IF($AE2,"CHRY"),

should be =IF($AE2="CHRY"), ?

 

[gsistek]

What is in $AE2? If you want to check if that is "CHRY" then try this:
=IF($AE2="CHRY", IF($E2="XX",'All BBK Age'!$A$1, VLOOKUP($H2,$AK:$AL,2,FALSE) + M2 - 1), IF($E2="XX",'All BBK Age'!$A$1,VLOOKUP($G2,$AK:$AL,2,FALSE)+I2-1))

 

[Jonmo1]

For one thing, you ENDED the first if with a ). You probably intended to NEST the 2nd If into the false part of the first if
=IF($AE2,"CHRY"), IF($E2="XX",'All BBK Age'!$A$1,...
Anything after that red ) doesn't really make sense..

Instead of asking to 'fix' a formula that doesn't do what you want..
Try explaining in words what you want to accomplish, then we can work on building a formula that does do what you want.