VLOOKUP and ISNA functions

[Steve ([email protected])]

I'm using the VLOOKUP function to lookup inventory in our database. How can
I set up the formula so that the #N/A will display 0 instead. I went to a
seminar and the instructor did this but I did not get to write the formula
down.

[Roger Govier]

Hi Steve

=IF(ISNA(your_formula),"",your_formula)

--
Regards
Roger Govier
"Steve ([email protected])" <Steve
([email protected])@discussions.microsoft.com> wrote in message
news:[email protected]...
> I'm using the VLOOKUP function to lookup inventory in our database. How
> can
> I set up the formula so that the #N/A will display 0 instead. I went to a
> seminar and the instructor did this but I did not get to write the formula
> down.

[Steve ([email protected])]

Thanks! Thats a HUGE help!


"Roger Govier" wrote:

> Hi Steve
>
> =IF(ISNA(your_formula),"",your_formula)
>
> --
> Regards
> Roger Govier
> "Steve ([email protected])" <Steve
> ([email protected])@discussions.microsoft.com> wrote in message
> news:[email protected]...
> > I'm using the VLOOKUP function to lookup inventory in our database. How
> > can
> > I set up the formula so that the #N/A will display 0 instead. I went to a
> > seminar and the instructor did this but I did not get to write the formula
> > down.
>
>
>