+ Reply to Thread
Results 1 to 8 of 8

Can I add blank space instead of 'FALSE' in VLookup?

  1. #1
    smithers2002
    Guest

    Can I add blank space instead of 'FALSE' in VLookup?

    Is this possible? Everytime I try to add in the " " formula, it returns an
    error message. I do not want n/a's appearing as a result of my Vlookup
    formula in my workbook. Thanks

  2. #2
    Bob Phillips
    Guest

    Re: Can I add blank space instead of 'FALSE' in VLookup?

    =IF(ISNA(lookup_formula),"",lookup_formula)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "smithers2002" <[email protected]> wrote in message
    news:[email protected]...
    > Is this possible? Everytime I try to add in the " " formula, it returns an
    > error message. I do not want n/a's appearing as a result of my Vlookup
    > formula in my workbook. Thanks




  3. #3
    smithers2002
    Guest

    Re: Can I add blank space instead of 'FALSE' in VLookup?

    Hi Bob, This doesnt seem to work- this is my lookup formula
    =VLOOKUP(Data!U2,maps,2,FALSE). It keeps saying there is an error when I
    insert this formula into the format below. Any ideas?

    Lynsey

    "Bob Phillips" wrote:

    > =IF(ISNA(lookup_formula),"",lookup_formula)
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "smithers2002" <[email protected]> wrote in message
    > news:[email protected]...
    > > Is this possible? Everytime I try to add in the " " formula, it returns an
    > > error message. I do not want n/a's appearing as a result of my Vlookup
    > > formula in my workbook. Thanks

    >
    >
    >


  4. #4
    CLR
    Guest

    Re: Can I add blank space instead of 'FALSE' in VLookup?

    Try this.......
    =IF(ISNA(VLOOKUP(Data!U2,maps,2,FALSE)),"TEST",=VLOOKUP(Data!U2,maps,2,FALSE
    ))

    All on one line, watch out for email wordwrap..........

    If it works then just delete the TEST from between the quotes.........

    Vaya con Dios,
    Chuck, CABGx3


    "smithers2002" <[email protected]> wrote in message
    news:[email protected]...
    > Hi Bob, This doesnt seem to work- this is my lookup formula
    > =VLOOKUP(Data!U2,maps,2,FALSE). It keeps saying there is an error when I
    > insert this formula into the format below. Any ideas?
    >
    > Lynsey
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(ISNA(lookup_formula),"",lookup_formula)
    > >
    > > --
    > >
    > > HTH
    > >
    > > RP
    > > (remove nothere from the email address if mailing direct)
    > >
    > >
    > > "smithers2002" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > Is this possible? Everytime I try to add in the " " formula, it

    returns an
    > > > error message. I do not want n/a's appearing as a result of my Vlookup
    > > > formula in my workbook. Thanks

    > >
    > >
    > >




  5. #5
    Bob Phillips
    Guest

    Re: Can I add blank space instead of 'FALSE' in VLookup?

    maybe stupid, but strip the = from your formula being inserting in my
    suggestion.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "smithers2002" <[email protected]> wrote in message
    news:[email protected]...
    > Hi Bob, This doesnt seem to work- this is my lookup formula
    > =VLOOKUP(Data!U2,maps,2,FALSE). It keeps saying there is an error when I
    > insert this formula into the format below. Any ideas?
    >
    > Lynsey
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(ISNA(lookup_formula),"",lookup_formula)
    > >
    > > --
    > >
    > > HTH
    > >
    > > RP
    > > (remove nothere from the email address if mailing direct)
    > >
    > >
    > > "smithers2002" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > Is this possible? Everytime I try to add in the " " formula, it

    returns an
    > > > error message. I do not want n/a's appearing as a result of my Vlookup
    > > > formula in my workbook. Thanks

    > >
    > >
    > >




  6. #6
    smithers2002
    Guest

    Re: Can I add blank space instead of 'FALSE' in VLookup?

    Thanks all its working now- the problem was a space I was putting in between
    the two "", as you normally would in an IF stmt etc

    Ta for your help

    "Bob Phillips" wrote:

    > maybe stupid, but strip the = from your formula being inserting in my
    > suggestion.
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "smithers2002" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hi Bob, This doesnt seem to work- this is my lookup formula
    > > =VLOOKUP(Data!U2,maps,2,FALSE). It keeps saying there is an error when I
    > > insert this formula into the format below. Any ideas?
    > >
    > > Lynsey
    > >
    > > "Bob Phillips" wrote:
    > >
    > > > =IF(ISNA(lookup_formula),"",lookup_formula)
    > > >
    > > > --
    > > >
    > > > HTH
    > > >
    > > > RP
    > > > (remove nothere from the email address if mailing direct)
    > > >
    > > >
    > > > "smithers2002" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > Is this possible? Everytime I try to add in the " " formula, it

    > returns an
    > > > > error message. I do not want n/a's appearing as a result of my Vlookup
    > > > > formula in my workbook. Thanks
    > > >
    > > >
    > > >

    >
    >
    >


  7. #7
    Alan Beban
    Guest

    Re: Can I add blank space instead of 'FALSE' in VLookup?

    smithers2002 wrote:
    > Thanks all its working now- the problem was a space I was putting in between
    > the two "", as you normally would in an IF stmt etc


    One wouldn't normally do that in an IF statement.

    Alan Beban

  8. #8
    smithers2002
    Guest

    Re: Can I add blank space instead of 'FALSE' in VLookup?

    ....it was to allow a blank space to be inserted if the answer to the If
    statement was false....

    "Alan Beban" wrote:

    > smithers2002 wrote:
    > > Thanks all its working now- the problem was a space I was putting in between
    > > the two "", as you normally would in an IF stmt etc

    >
    > One wouldn't normally do that in an IF statement.
    >
    > Alan Beban
    >


+ 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