Closed Thread
Results 1 to 4 of 4

lookup value - true/false

  1. #1
    Peter
    Guest

    lookup value - true/false

    A1= value to look for in B1:B500
    if it finds A1 in B1:B500 I want it to return C1.
    I can use a VLookup ok, except when doesn't find A1 it returns a #N/A.
    I've tried a IF statement around the VLookup, but still runs into the #N/A
    issue.
    Any suggestions?

  2. #2
    L. Howard Kittle
    Guest

    Re: lookup value - true/false

    if(isna(vlookup(a1,b1:b500,2,0)),"",(vlookup(a1,b1:b500,2,0))

    HTH
    Regards,
    Howard

    "Peter" <[email protected]> wrote in message
    news:[email protected]...
    > A1= value to look for in B1:B500
    > if it finds A1 in B1:B500 I want it to return C1.
    > I can use a VLookup ok, except when doesn't find A1 it returns a #N/A.
    > I've tried a IF statement around the VLookup, but still runs into the #N/A
    > issue.
    > Any suggestions?




  3. #3
    L. Howard Kittle
    Guest

    Re: lookup value - true/false

    woops.

    Change b500 to c500

    Regards,
    Howard

    "L. Howard Kittle" <[email protected]> wrote in message
    news:[email protected]...
    > if(isna(vlookup(a1,b1:b500,2,0)),"",(vlookup(a1,b1:b500,2,0))
    >
    > HTH
    > Regards,
    > Howard
    >
    > "Peter" <[email protected]> wrote in message
    > news:[email protected]...
    >> A1= value to look for in B1:B500
    >> if it finds A1 in B1:B500 I want it to return C1.
    >> I can use a VLookup ok, except when doesn't find A1 it returns a #N/A.
    >> I've tried a IF statement around the VLookup, but still runs into the
    >> #N/A
    >> issue.
    >> Any suggestions?

    >
    >




  4. #4
    Peter
    Guest

    Re: lookup value - true/false

    Ok, that makes some sense, but for some reason it reverses my problem. It
    blanks the ones that it can't find (which is good), but gives me a REF on the
    ones it does find...Hmm

    Whoops! Just needed to customize it a little more so the value if true was a
    cell reference...
    THANKS!

    Peter

    "L. Howard Kittle" wrote:

    > if(isna(vlookup(a1,b1:b500,2,0)),"",(vlookup(a1,b1:b500,2,0))
    >
    > HTH
    > Regards,
    > Howard
    >
    > "Peter" <[email protected]> wrote in message
    > news:[email protected]...
    > > A1= value to look for in B1:B500
    > > if it finds A1 in B1:B500 I want it to return C1.
    > > I can use a VLookup ok, except when doesn't find A1 it returns a #N/A.
    > > I've tried a IF statement around the VLookup, but still runs into the #N/A
    > > issue.
    > > Any suggestions?

    >
    >
    >


Closed 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