+ Reply to Thread
Results 1 to 3 of 3

Thread: Issue:if statement problem

  1. 06-29-2011, 10:37 AM #1
    step_one
    step_one is offline
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    Issue:if statement problem

    Hi

    Having some issue trying to place the logic in my if statement

    =IF(OR(D2="",D2="0"),"",VLOOKUP(D2,'All stores'!$C$10:$S$954,17,FALSE))


    basically, i would like to further show,

    if the vlookup = "" then show ""

    so basically, if the vlookup answer is a blank, show a blank; it is currently showing a 0 instead.

    thx you so much!
    Reply With Quote Reply With Quote
  2. 06-29-2011, 11:08 AM #2
    edvwvw
    edvwvw is offline
    Forum Contributor
    Join Date
    05-27-2008
    Location
    Newcastle Upon Tyne UK
    MS-Off Ver
    XP Excel 2003
    Posts
    105

    re: Issue:if statement problem

    =IF(D2="","",IF(D2=0,"",VLOOKUP(D2,'All stores'!$C$10:$S$954,17,FALSE)))

    edvwvw
    Reply With Quote Reply With Quote
  3. 06-29-2011, 11:13 AM #3
    jw01
    jw01 is offline
    Valued Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Prefer Excel 2003 but 2007 is great!
    Posts
    611

    re: Issue:if statement problem

    try placing T, before vlookup
    Last edited by jw01; 06-29-2011 at 11:21 AM.
    Reply With Quote Reply With Quote
+ Reply to Thread
« 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.2.0