Hi,

I have a list in a worksheet "Clients",
this includes
1) ABC
2) SHELL
3) CHEVRON
........
The list actually includes 50 clients.

In cell A1 of Worksheet "Summary" if someone enters a Client in this list
a message box should prompt "This is a key Client"

The slight catch is, if someone enters a derivative e.g. ABC Ltd, ABC
Worldwide, ABC Co, the message box should still appear .

Thanks