Forum Discussion

rachel1205's avatar
rachel1205
Copper Contributor
Jan 23, 2022
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...
Formulas and Functions
rachel1205's avatar
rachel1205
Copper Contributor
Jan 31, 2022
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.
  • rachel1205's avatar
    rachel1205
    Copper Contributor
    Feb 01, 2022
    It worked. Thanks a bunch for your help.

Resources