Assuming your long list is in E1:E500, and the code you want to check is in
B1, use

=if(countif($e$1:$e$500,B1)=0,"Not in List","")

copy it down for all the vlaues you want to test

"Alok Kumar" wrote:

Hi All,

I am new here and I need your help. Well, I have column called hotel_code
and it has some values, now I need to crossckeck these values against the
list of values and popup a massase, if any of the values are not available in
the column. For Example

Hotel_code

DELTR
BOMHI
BBITR

Now, my requirement to crosscheck these values against the list
(DELTR,BOMHI,BBITR,COKTR, MAATR). Now in the column hotel_code, it does not
list COKTR and MAATR. Now, I want a popup massage which would able to
indicates, these values (COKTR and BBITR) is missing.

hare krishna
Alok

--
none
none
none
none