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