IF(OR statement not working
=IF(OR(ISNUMBER(MATCH(H3,PastLoad!$H3,0))*MATCH(F3 ,PastLoad!$F3,0)),"","NEW")
Can't figure out how to get a text-numeric value to match in an If(or statement. Pretty sure its something so simple that someone with more experience with me will recognize immediately.
Thanks.
attachment included
|