+ Reply to Thread
Results 1 to 2 of 2

Vlookup: Need empty cells to appear as blank instead of 0

  1. #1
    Forum Contributor
    Join Date
    05-07-2007
    Location
    Singapore
    MS-Off Ver
    2006/2016
    Posts
    170

    Vlookup: Need empty cells to appear as blank instead of 0

    Test.xls

    I'm having trouble in the Converter_Output part of my file

    I'll paste a system generated report into Converter Input and I'll take the results from Converter_Output for my own use.

    What happens is that there is a good chance that the cells for Remarks and Comments is empty in the input, but when I view the results in Converter_Output I want any empty cells (which vlookup wil display as 0), to display as blank cells instead

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Vlookup: Need empty cells to appear as blank instead of 0

    Usual solution is

    IF(VLOOKUP(your formula)=0,"",VLOOKUP(your formula))
    ie, If the VLOOKUP returns 0 replace it with a blank otherwise perform the VLOOKUP
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. Pivot table in blank cells it says blank.... i want it empty
    By appell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-27-2014, 09:43 AM
  2. Replies: 4
    Last Post: 03-08-2014, 02:03 PM
  3. [SOLVED] Need help : Vlookup/index with skip blank/empty cell, problem!!!!
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2013, 12:18 AM
  4. Replies: 2
    Last Post: 07-25-2013, 01:01 PM
  5. Replies: 5
    Last Post: 01-12-2013, 12:16 AM

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