Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
[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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL statement not working | Excel Programming | |||
IF Statement not working | Excel Worksheet Functions | |||
IF statement not working | Excel Discussion (Misc queries) | |||
If statement not working | Excel Programming | |||
If statement not working right | Excel Programming |