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

[Guest]

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

 

[Bob Phillips]

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

--

HTH

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

 

[Guest]

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

 

[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

 

[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)

 

[Guest]

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

 

[Alan Beban]

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

 

[Guest]

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