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.
Thank you for the tip, however, now I am getting a Value error. I did as you suggested, and put double quotes around Fixed Expenses etc... and the 308-0 etc..
Any idea why I am getting a value error now?
Could you attach a sample workbook demonstrating the problem, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- How do I attach a sample workbook?
Some but not all users see an area "Drag and drop here or browse files to attach" below the area where you compose a reply.
If you see it, simply drag the workbook from Windows Explorer (or Finder) into that area.
If not, you'll have to follow the other suggestion from my previous reply.
- Hi Hans,
I will get this to you via One Drive this weekend.
Thank you for all of your help.