Results 1 to 6 of 6

vlookup displays "0" if reference cell is blank?

Threaded View

Back2Basics vlookup displays "0" if... 01-22-2009, 12:49 PM
mewingkitty Could change the last section... 01-22-2009, 12:55 PM
Back2Basics I had tried that, it seems... 01-22-2009, 01:00 PM
Back2Basics And thank you Donkey, if that... 01-22-2009, 01:02 PM
Back2Basics Quote: First off let me point... 01-22-2009, 01:04 PM
DonkeyOte =IF(OR($C$4="",$C$4="No... 01-22-2009, 12:57 PM
  1. 01-22-2009, 12:49 PM #1
    Back2Basics is offline
    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.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1