ExcelBanter - Using the VLOOKUP Command

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

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

- - Using the VLOOKUP Command (https://www.excelbanter.com/excel-worksheet-functions/116483-using-vlookup-command.html)

Glen Disteafno

Using the VLOOKUP Command

Is there a way to not get a #N/A when a lookup in invalid. I would
rather have a -0- appear?
Glen

Niek Otten

Using the VLOOKUP Command

=IF(ISNA(YourFormula),"-0-",YourFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Glen Disteafno" wrote in message news:43u0h.24$Z66.6@trnddc07...
| Is there a way to not get a #N/A when a lookup in invalid. I would
| rather have a -0- appear?
| Glen

Biff

Using the VLOOKUP Command

Hi!

One way:

=IF(ISNA(VLOOKUP(A1,B1:C10,2,0)),0,VLOOKUP(A1,B1:C 10,2,0))

Biff

"Glen Disteafno" wrote in message
news:43u0h.24$Z66.6@trnddc07...
Is there a way to not get a #N/A when a lookup in invalid. I would rather
have a -0- appear?
Glen

All times are GMT +1. The time now is 01:18 AM.