IF(ISNA(YourFormula),0,YourFormula)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Adam at GTOFL" <Adam at wrote in message
...
When searching multiple tables with a V or HLOOKUP formula, I want a
search
that doe not find anything to result in a zero instead of an error (#N/A)

I have tried a variations of IF formulas but am missing something.

Thanks