If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
trying to create an (almost) circular formula between cells and data validated cells with lists
All on one worksheet, I have a bunch of data validated cells in multiple
columns and rows (ranging from B24 to K68) which pull from a master name list in L2:L50. An exact match is not required, allowing me to type new names in the data validated cells if the name I want isn't already on the list. What I'd like to do is put a formula in my unused list cells that reference the range of data validated cells [and the names above itself in the list], and if it finds a name that /is/ in the data validated cells but /isn't/ in the list, show that value in the cell- essentially, so if I (or another user) types in a new name, it also is automatically added to the main list and is thereafter available in any of the other data validated cells/lists without having to re-type it. My brain hurts just thinking about it- so before I spend a lot of time, has anyone else set something like this up, and if so, can you share what approach you found most workable? Thanks!! Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a conditional formula to change the value of other cells | Orca | General Discussion | 1 | April 6th, 2005 04:23 PM |
How to create a formula for this function. | How to create a forrmula | Worksheet Functions | 1 | April 6th, 2005 07:22 AM |
use a formula to create a empty cell | Chas | Charts and Charting | 1 | October 27th, 2004 11:14 PM |
how do i create an excel formula to work out a date x amount of w. | Ska | General Discussion | 2 | October 12th, 2004 01:55 PM |
How do I create a formula that picks the last entry | Dave | Worksheet Functions | 3 | December 9th, 2003 11:02 AM |