How do I change a default value associated with a VLookup?

[mlrmlr]

Hello,

How can I change a preformatted value in an Excel spreadsheet from "#N/A" to "n/a"?

I inherited a spreadsheet that I have to populated daily and my results are pulling from this lookup [=VLOOKUP(B8,Order!$A$2:Order!AI17:BP243,34,FALSE)]. If the value is in the lookup sheet then it is fine. If the value is not in the lookup sheet it fills the cells with "#N/A". I would like to change the default #N/A to n/a.

Any help is appreciated.

Thanks.

 

[fneily]

A shorter example:
=IF(ISERROR(VLOOKUP(A1,G1:H3,2,FALSE)),"n/a",VLOOKUP(A1,G1:H3,2,FALSE))

 

[yogia]

Hi mlrmlr:

In addition to the suggestion by fneily, also ...

=IF(ISNA(VLOOKUP(formula)),"n/a",VLOOKUP(formula))

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com