Hi,

I have a list in worksheet "Clients"

1) Shell
2) ABC
3) Chevron
etc.etc.

(Actually over 100 Clients)

I have a separate sheet "Summary",

if an individual enters a Client in cell A1 which is one of thes
Clients,
a message box prompts "You have entered a key client"

Slight catch is that if the client entered is a derivative of one o
the list
e.g. ABC Co, ABC Ltd
Then the message box still appears.

Thank

--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=56060