| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Great, thanks!!
"Bernie Deitrick" wrote: Mac, The MATCH function will return an Error if there is no match, so you can check to see if you new value is in your old table by using a formula like =IF(ISERROR(MATCH(CellWithNewValue,OldTable,False) ),"This isn't in our Table!","OK") where you need to change CellWithNewValue and OldTable to valid cell and range references, respectively. HTH, Bernie MS Excel MVP "Mac Landers" wrote in message ... Good Morning! I have a list of products that comes from another group. Occassionaly a new customer is added and they do not inform us - when we run our formulas to populate the numbers it doesn't populate; however, it is difficult to notice because there are not always numbers for the products so there are many blank cells and it just appears that there were no orders. I am looking for a way to sweep through the list of products and find any products that do not match my tabled list of current products on the next worksheet. Any assistance in greatly appreciated. Thank you! Mac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| search with drop down list | Excel Worksheet Functions | |||
| How do I create a "List If" function.I need to search a database . | Excel Worksheet Functions | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Hybrid Mode
