| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find number within two data base
Think a better alternative to use is:
=IF(AND(ISNUMBER(MATCH(A1,Accept,0)),ISNUMBER(MATC H(A1,Reject,0))),"Check",IF(ISNUMBER(MATCH(A1,Acce pt,0)),"Accepted",IF(ISNUMBER(MATCH(A1,Reject,0)), "Rejected",""))) If A1 is somehow found in *both* Accept & Reject, it'll alert you via returning: "Check" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find number in a data base | Excel Worksheet Functions | |||
| How do I automatically add 1 day to a base number every day? | Excel Worksheet Functions | |||
| How do I set the number format to Base 12? | Excel Discussion (Misc queries) | |||
| Access data base is able to store any number of records | Excel Worksheet Functions | |||
| Can you change the base number from 100 to something else with %'s | Excel Worksheet Functions | |||
Threaded Mode
