View Single Post
  #1   Report Post  
Adam at GTOFL
 
Posts: n/a
Default 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