| 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 | |||
Hybrid Mode
