View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alok Kumar Alok Kumar is offline
external usenet poster
 
Posts: 2
Default Crosscheck values against the list of values.

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