I have a spreadsheet that has three tabs. The data will change depending on the user. I need to have a list of user generated data to lookup a second list of user data. I don't want the end user to use the Name Manager rename the lists, so I have a static lookup list.
This spreadsheet should explain what I am looking for:
indirect of indirect.xlsx
1) I wouldn't use INDIRECT at all, I would use OFFSET so it can be dynamic and cascading.
2) I would recommend you put your configuration values on a single setup sheet.
The first list consists of all the values in row1.
The secondary lists consist of all the values in those columns below the row1 values.
Check the example shown, only one named range is in use, that is SNAME. The Data Validation formula under RESULT is figuring out the rest all on its own.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I will have to replicate the data in another spot to get it like that, that should be very little effort. I will give it a try ASAP!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks