Blank Cell instead of #N/A

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

learning_codes@hotmail.com - 31 Dec 2007 23:57 GMT

Hi,

=VLOOKUP(A40,'WITH GOOD'!$A$2:$D$1000,2)

Is there a way to show "blank cell" instead of #N/A in the cell
"A40"?

Thanks

Reply to this Message

Max - 01 Jan 2008 00:12 GMT

Try:

=IF(ISNA(VLOOKUP(A40,'WITH GOOD'!$A$2:$D$1000,2)),"",VLOOKUP(A40,'WITH
GOOD'!$A$2:$D$1000,2))

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Traveller - 01 Jan 2008 18:04 GMT

If your concern is how your spreadsheet prints and not with how it looks on
the monitor, go to Page Setup, and on the "Sheet" tab about two-thirds of the
way down choose, "Cell errors as: <blank>".

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

pleclerc@excel-vba.com - 02 Jan 2008 15:33 GMT

On Dec 31 2007, 6:57 pm, "learning_co...@hotmail.com"
<learning_co...@hotmail.com> wrote:

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks

You can use ISNA or the ISERROR that covers all errors.

See an easy way to do this in chapter 10 of

http://www.excel-vba.com/excel-10-iserror.htm

Reply to this Message