View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh Johansen Josh Johansen is offline
external usenet poster
 
Posts: 72
Default Formula to find a value in a list that doesnt match another list

I have a data page with 8000 entries, one column in those entries is a
location in just numbers. I have a lookup table referenced to so that I can
change those numbers into a location name. If someone adds a new number I
will know and the lookup function will just go to the next lowest value and
name it to that area. I am trying to figure out a way that a formula would
tell me that someone has added a new number. Any ideas? Thanks.