Many thanks to: Ron Coderre, Peo Sjoblom, CLR Pete_UK and Rick Rothstein
(MVP-VB)
I'm trying out ALL of your suggestions.
I've obviously come to the right place.
Thanks again.
-Kevin

"Rick Rothstein (MVP - VB)" wrote in
message ...
Although not what you asked for, you may want to consider this alternative
approach. Instead of flagging invalid numbers with the word "Invalid",
what about if you highlight invalid entries by shading the cell it is
in... or, perhaps, changing the color of its text. Give this a try...
highlight the range of cells A1:A24 and click on...

Format/Conditional Formatting

in Excel's menu. Select "Formula Is" in the first drop-down box and paste
this formula...

=AND(NOT(COUNTIF(MasterList,A1)),A1<"")

in the next field. Now, click the Format button and pick a method of
display you want to see for your invalid values. For example, to turn the
text for invalid entries red, click the Font tab and pick a red color from
the Color drop down. (You can experiment with the other possible cell
formats in case you don't like the text color option.) Okay your way back
to the spreadsheet. Now, enter valid and invalid entries in the A1:A24 to
see the effect.

Rick


"Kevin" wrote in message
...
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