I have this match formula below. As it stands, it matches A4 to column G and return what is in column H. However, if it can't match anything, it returns a # N/A. I need it to return a 0 or a blank if it can't find anything.
How can I adjust my formula to do that?
=INDEX($H:$H,MATCH(TEXT($A4,"ddd m/d/yyyy"),$G:$G,0))
Bookmarks