| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stumped: Find first match in list then reference dif cell in row.. | Excel Discussion (Misc queries) | |||
| Find a match in a list | Excel Discussion (Misc queries) | |||
| Find closest text match for each unique entry in a list | Excel Discussion (Misc queries) | |||
| Using the MATCH formula and list the duplicates | Excel Worksheet Functions | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
Threaded Mode
