ExcelBanter - IF(OR statement not working

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF(OR statement not working (https://www.excelbanter.com/excel-worksheet-functions/449305-if-statement-not-working.html)

AndersonJameson

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

AndersonJameson

[quote=AndersonJameson;1614071]=IF(OR(ISNUMBER(MATCH(H3,PastLoad!$H3,0))*MATCH(F3 ,PastLoad!$F3,0)),"","NEW")

Sorry, my the simple excel spreadsheet I tried to upload was to large to upload to this site even when zipped.

MyVeryOwnSelf[_3_]

IF(OR statement not working

=IF(OR(ISNUMBER(MATCH(H3,PastLoad!$H3,0))*MATCH(F3 ,PastLoad!$F3,0)),"","NEW")

The post doesn't say much about the objective or about what's going wrong, but if I had to make a wild guess maybe this would help:

=IF(OR(ISNUMBER(MATCH(H3,PastLoad!$H3,0)),
ISNUMBER(MATCH(F3,PastLoad!$F3,0))),"","NEW")

All times are GMT +1. The time now is 07:10 AM.