+ Reply to Thread
Results 1 to 4 of 4

Stock list using Vlookup, need the price field to read as TBA is stock on hand is 0

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 365
    Posts
    20

    Stock list using Vlookup, need the price field to read as TBA is stock on hand is 0

    I have a stocklist, auto populating the description, SOH and pricing from a second sheet using vlookup. I need the price to show as TBA if the SOH reads as 0. I have tried =IF(D4=0,"TBA","(=VLOOKUP(A4,Sheet2!A:E,4,false))") to no avail, TBA shows if zero, but the vlookup does not calculate). Suggestions?demo fo TBA dollar.xlsx

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,239

    Re: Stock list using Vlookup, need the price field to read as TBA is stock on hand is 0

    change your formula to =IF(D4=0,"TBA",VLOOKUP(A4,Sheet2!A:E,4,FALSE))

  3. #3
    Registered User
    Join Date
    04-24-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 365
    Posts
    20

    Re: Stock list using Vlookup, need the price field to read as TBA is stock on hand is 0

    perfect fix,

    thanking you immensely

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,239

    Re: Stock list using Vlookup, need the price field to read as TBA is stock on hand is 0

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy price to more than one product - Stock List
    By Ben1985 in forum Excel General
    Replies: 2
    Last Post: 08-11-2014, 12:42 PM
  2. Total sold price according to stock price list
    By maniootek in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-26-2014, 10:54 PM
  3. Replies: 4
    Last Post: 01-29-2013, 02:26 AM
  4. Replies: 3
    Last Post: 01-03-2013, 12:32 AM
  5. Replies: 0
    Last Post: 10-28-2012, 07:22 AM
  6. Replies: 2
    Last Post: 06-28-2005, 12:05 PM

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