+ Reply to Thread
Results 1 to 1 of 1

IF(ISBlank with Vlookup

  1. #1
    Registered User
    Join Date
    10-24-2005
    Location
    Lake Forest, CA
    MS-Off Ver
    2007
    Posts
    56

    IF(ISBlank with Vlookup

    =IF(ISBLANK(Q19),"-",VLOOKUP('ITEM ADD-CHG Form'!Z19,Brand_V,2,FALSE))

    If cell Q19 is blank, return a dash
    If cell Q19 is not blank, run a Vlookup on cell Z19 against named range Brand_V and return value of column 2

    I'm getting a dash, when cell Q19 is *not* blank

    If I run the VLookup string
    =VLOOKUP('ITEM ADD-CHG Form'!Z20,Brand_V,2,FALSE)
    I get the proper answer. When I insert the IF(ISBLANK statement, I'm getting the dash.
    Last edited by amthyst826; 02-23-2010 at 01:11 PM. Reason: Figured it out. Bad cell reference.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1