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

**meerabell** · 08-30-2015, 09:10 PM

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

**alansidman** · 08-30-2015, 09:15 PM

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

**meerabell** · 08-30-2015, 10:47 PM

perfect fix,

thanking you immensely

**alansidman** · 08-31-2015, 07:42 AM

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

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy price to more than one product - Stock List

Total sold price according to stock price list

Stock inventory, subtract purchased stock from current stock and continue with second row

unit price - Cost price with condition (date, price, and stock)

How to get current stock price and previous close of a stock from National Stock Exchange

how to copy old price data onto new stock list if match exists?

Bookmarks

Bookmarks

Posting Permissions