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

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

--

HTH

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


"smithers2002" wrote in message
...
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" wrote in message
...
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",=VL OOKUP(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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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