VLOOKUP and ISNA functions

[Guest]

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]...

 

[Guest]

Thanks! Thats a HUGE help!

Hi Steve

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

--
Regards
Roger Govier
"Steve ([email protected])" <Steve
([email protected])@discussions.microsoft.com> wrote in message