How about this:
Just remove the additional "=" signs.![]()
=IF(B2>'Item List'!D3,0,vlookup(A2,'Item List'!A2:F17,4,false)-vlookup('Item List'!A3,Inventory!A1:E16,2,false))
Cheers,
How about this:
Just remove the additional "=" signs.![]()
=IF(B2>'Item List'!D3,0,vlookup(A2,'Item List'!A2:F17,4,false)-vlookup('Item List'!A3,Inventory!A1:E16,2,false))
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)
Bookmarks