I am making an if function that has 2 vlookups that make up the if false statement. i have it as this =IF(B2>'Item List'!D3,0,=vlookup(A2,'Item List'!A2:F17,4,false)-=vlookup('Item List'!A3,Inventory!A1:E16,2,false)) but i keep getting an error message. I've been working on this for a few hours now and its about to drive me crazy. any help would be a huge help.
Last edited by sjhill60; 10-13-2011 at 11:05 PM.
How about this:
Just remove the additional "=" signs.
Please Login or Register to view this content.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks