How do I create a formula to retun a value of 0 (zero) when a VLO.
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
|