Results 1 to 2 of 2

vlookup functions within if functions.

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2011
    Location
    usa
    MS-Off Ver
    Excel 20011
    Posts
    5

    vlookup functions within if functions.

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1