Doug Jefferson
Board Regular
- Joined
- Nov 4, 2010
- Messages
- 60
=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
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