Hi, what macro do i need to creat message that this value is not in
the list. like if i put some value in any cell of coloumn A in sheet 1
and it looks up that value into coloumn B of sheet 2 and if the value
is not there the message should pop up that this value is not in the
list. the macro should just bring the message and do nothing else and
you can still put new value in coloumn A.
Plese is there anybody can help. Thanks........