Results 1 to 6 of 6

vlookup displays "0" if reference cell is blank?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Cardiff
    MS-Off Ver
    2003
    Posts
    123

    vlookup displays "0" if reference cell is blank?

    I am trying to use vlookup so that when each site name is selected the relevant comments for that site are displayed.

    I have a formula that is working, but it displays "0" if there is nothing in the cell. How do i get it to display a blank cell if thre is nothing in the reference cell.

    this is the formula that i am using:

    =IF($C$4="", "", IF($C$4="No Match", "", (VLOOKUP($C$4,Comments!$A$2:$U$295, 5,0))))

    The site name appears in C4, and is selected from another sheet in the workbook.
    Last edited by Back2Basics; 01-22-2009 at 01:02 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