+ Reply to Thread
Results 1 to 3 of 3

Return a text string when the result of VLOOKUP formula is #N/A

  1. #1
    jeremy nickels
    Guest

    Return a text string when the result of VLOOKUP formula is #N/A

    Is there any way to have the result of a VLOOKUP formula be the text string
    "NO" instead of #N/A when it doesn't find a match?

    I'm playing around with an IF statement and the ERROR.TYPE function, but I'm
    not quite getting it.

  2. #2
    Guest

    Re: Return a text string when the result of VLOOKUP formula is #N/A

    Hi

    One approach:
    =IF(ISERROR(VLOOKUP______),"ERROR",VLOOKUP_______)

    Hope this helps.
    Andy.

    "jeremy nickels" <[email protected]> wrote in message
    news:[email protected]...
    > Is there any way to have the result of a VLOOKUP formula be the text
    > string
    > "NO" instead of #N/A when it doesn't find a match?
    >
    > I'm playing around with an IF statement and the ERROR.TYPE function, but
    > I'm
    > not quite getting it.




  3. #3
    jeremy nickels
    Guest

    Re: Return a text string when the result of VLOOKUP formula is #N/

    Perfect.

    Thank you.

    "Andy" wrote:

    > Hi
    >
    > One approach:
    > =IF(ISERROR(VLOOKUP______),"ERROR",VLOOKUP_______)
    >
    > Hope this helps.
    > Andy.
    >
    > "jeremy nickels" <[email protected]> wrote in message
    > news:[email protected]...
    > > Is there any way to have the result of a VLOOKUP formula be the text
    > > string
    > > "NO" instead of #N/A when it doesn't find a match?
    > >
    > > I'm playing around with an IF statement and the ERROR.TYPE function, but
    > > I'm
    > > not quite getting it.

    >
    >
    >


+ 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