Is there a way to have the Vlookup formula return a 0 value if there is not a match. Currently, if the formula doesn't find a match, it returns an output of #N/A. I need to convert it to a numeric value.
Formula I'm using:
=VLOOKUP(A2,'page1'!$A$1:$B$3795,2,FALSE)
thanks
Formula I'm using:
=VLOOKUP(A2,'page1'!$A$1:$B$3795,2,FALSE)
thanks