VLOOKUP

[mmwater]

Hi,

Is there a way to stop ' VLOOKUP ' function returning the result ' #N/A ' when it cant find something. I need a neutral answer e.g. ' 0 ' or ' - ' otherwise other formulas on my page using this cell wont work either - all I get ' #N/A ' everywhere. Any ideas appreciated.

Regards
Wendy

 

[JohnnyTightlips]

this should work:

If(isna(YourVlookupFormula),0,YourVlookupformula))

 

[mmwater]

Yes, this works - thanks very much for your help

bye,

Wendy

 

[PaddyD]

http://www.mrexcel.com/board2/viewtopic.php?t=62102