Can I add blank space instead of 'FALSE' in VLookup?

S

smithers2002

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
 
B

Bob Phillips

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

--

HTH

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

smithers2002

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
 
C

CLR

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
 
B

Bob Phillips

maybe stupid, but strip the = from your formula being inserting in my
suggestion.

--

HTH

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

smithers2002

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
 
A

Alan Beban

smithers2002 said:
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
Click to expand...

One wouldn't normally do that in an IF statement.

Alan Beban
 
S

smithers2002

....it was to allow a blank space to be inserted if the answer to the If
statement was false....
 
Top