LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 12th 05, 07:21 PM
Posts: n/a
Default 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

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?


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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I create a if-then formula? karen Excel Worksheet Functions 1 May 3rd 05 09:19 PM
How to create specific formula STS Excel Worksheet Functions 4 May 2nd 05 01:44 AM
Create Formula Lazia Excel Discussion (Misc queries) 2 April 25th 05 04:09 PM
In two workbooks, how do I create a formula that will look at a o. socaldave469 Excel Discussion (Misc queries) 1 April 22nd 05 10:01 PM
create a chart with a formula anon Charts and Charting in Excel 1 December 15th 04 08:55 PM

All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017