| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation - Error message if equals Left formula
I have a project code in column A formatted as general and the user should be
entering 4 digits dash 3 digits (0001-000). In column B and C the user needs to break out each part of those numbers. In B they need to type 0001 and in C they type 000. I wanted to place a data validation in B that gives the user an error message is the number typed in B do not equal the left 4 characters in A. Same for B with the right 3 characters of A. I've tried a few things but I can't get the formula right. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) | |||
| Can I have error message when formula is over value? | Excel Worksheet Functions | |||
| Error message #NAME from formula | Excel Discussion (Misc queries) | |||
| Error message #NAME from formula | Excel Worksheet Functions | |||
| Error Message with Data Validation | Excel Discussion (Misc queries) | |||
Threaded Mode
