Its a easy dumb question.

[comotoman]

When i have formulas with there criteria not fullfilled, i get the "#N/A". How do i get that to go away?

[BenjieLop]

When i have formulas with there criteria not fullfilled, i get the "#N/A". How do i get that to go away?

One way ...

=if(iserror(your_formula)," ",your_formula)

will take care of this problem of yours.


Regards.

[MDOTJR]

you still have an error on your formula...so you know

[comotoman]

=if(iserror(VLOOKUP(A9,$C$154:$G$680,2,FALSE)," ",VLOOKUP(A9,$C$154:$G$680,2,FALSE)))

i get an error message base on the " "

[comotoman]

Please Help!!!

[Alan]

Thats
=IF(ISERROR(VLOOKUP(A9,$C$154:$G$680,2,FALSE)),"",VLOOKUP(A9,$C$154:$G$680,2,FALSE))
"comotoman" <[email protected]> wrote
in message news:[email protected]...
>
> =if(iserror(VLOOKUP(A9,$C$154:$G$680,2,FALSE),"
> ",VLOOKUP(A9,$C$154:$G$680,2,FALSE)))
>
> i get an error message base on the " "
>
>
> --
> comotoman
> ------------------------------------------------------------------------
> comotoman's Profile:
> http://www.excelforum.com/member.php...o&userid=27292
> View this thread: http://www.excelforum.com/showthread...hreadid=468285
>

[comotoman]

That did the trick, thank you all for the help!

[Alan]

Youre welcome,
Alan.
"comotoman" <[email protected]> wrote
in message news:[email protected]...
>
> That did the trick, thank you all for the help!
>
>
> --
> comotoman
> ------------------------------------------------------------------------
> comotoman's Profile:
> http://www.excelforum.com/member.php...o&userid=27292
> View this thread: http://www.excelforum.com/showthread...hreadid=468285
>