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