Message Box

[Francesco Pedra]

Hi all,
What I am looking to do is the following:
When I type on a specific column a value, I will like that the syste
compares the value against a table or a list and display a message

I have some customer that I have to give them a special %, so I wil
like to have a message box appear with the amount of % I have to giv
if that specific name is typed on the Customer column.

Regards
Chec

 

[Frank Kabel]

Hi
why not use a helper column. e.g. you enter the customer name in A1
and X1:X10 contains your list of customers. Then enter in B1:
=IF(COUNTIF($X$1:$X$10,A1),"special customer","")

--
Regards
Frank Kabel
Frankfurt, Germany

"Francesco Pedra" <[email protected]>
schrieb im Newsbeitrag
news:[email protected]...