Using the VLOOKUP Command

[Glen Disteafno]

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]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

 

[Biff]

Hi!

One way:

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

Biff