Forum Discussion
Solved
Can someone tell me why I keep getting a naming error on this formula?
=IF(AND(VLOOKUP(I2,Accounts!A:E,5,0)=FIXED EXPENSES,R2=308-0),Bgt_FixedExp!D:D,0),IF(AND(VLOOKUP(I2,Accounts!A:E,5,0)=MATTRESS Revenue,R2=101-1),Bgt_Mattress!F:F,0),IF(AND(VLOOKUP(I2,Accounts!A:E,5,0...
Try this then.
That doesn't make much sense. See if the attached version does what you want.
No, it does not work. Row 5 should return a value of -16083, which is from column D in the Bgt_FixedExp tab and Row 20 should return a value of -7500, which is from column D in the Bgt_FixedExp tab also. All other values for column 2-21 should be 0. I hope this helps.
- It worked. Thanks a bunch for your help.
Try this then.