You can do this with Data | Validation. This pops up a panel in 3
parts - you can specify a message (comment) to display when the cell
is selected, you can specify what values are acceptable (eg your
MasterList), and you can also specify what to do in the event of
invalid data being entered. No need for a convoluted IF statement !!

Hope this helps.

Pete

On Aug 7, 3:44 pm, "Kevin" wrote:
Dear NG:

Is there any way to have Excel check numbers being entered into a range
against a master list of numbers.

Lets say the master list is a named range MasterList (=Sheet1!$H$1:$H$10)
consisting of 10 sequential numbers from 70 thru 79.

Any data entered into named range PartNumberList (=Sheet1!$A$1:$A$24) must
be checked against the master list.

Any number entered into PartNumberList that IS listed in MasterList is just
displayed normally as the number itself.

Any number entered into PartNumberList that is NOT in MasterList is
displayed as the number itself but ammended with "Invalid"

I'm sensing some sort of convoluted IF statement.

Thanks for any help with this.

-Kevin