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.
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.
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.
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.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks