ExcelBanter - VLOOKUP and ISNA functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP and ISNA functions (https://www.excelbanter.com/excel-worksheet-functions/34525-vlookup-isna-functions.html)

Steve ([email protected])

VLOOKUP and ISNA functions

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 )" <Steve
wrote in message
...
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 )" <Steve
wrote in message
...
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.

All times are GMT +1. The time now is 08:56 AM.