Hi experts!
I need basically to have a one list out of two. Both listed are named as lstPlanningID and lstContactID
I don't need to check if they are repeated or not. I just need them to be in one unique list so it can be used as a data validation entry (drop-drown list)
Any idea how to do that?
Best,
Gerónimo
As far as I'm aware you can't combine two named listsas a source for a data validation drop down.
You will have to create a separate single list and use that.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks, Richard!
How do I do it?
Hi,Originally Posted by gerotutu
I had assumed you would copy one list underneath the other. Or am I missing some subtlety in your request?
I wanted to make a unique list dinamically but I came up with that solution that worked. Thanks, Richard.
I think we will need to see an example of what you are working with.
Questions I anticipate from a formula perspective:An uploaded Excel wb file (and not a pic or screen shot) saves everyone from guessing.
- Are the ranges of lstPlanningID and lstContactID next to each other?
- Are they the same size?
- How are those ranges defined? Are they absolute ... dynamic named ranges ... mixed?
- Other issues unforeseen.
If you are not familiar with how to do this:
To attach a file to your post,The file name will appear at the bottom of your reply.
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
- be sure to desensitize the data
Dave
Thanks, FlameRetired!
- Are the ranges of lstPlanningID and lstContactID next to each other? No, they are in different sheets.
- Are they the same size? No, the first one is around 12 rows and the second one around 5000.
- How are those ranges defined? Are they absolute ... dynamic named ranges ... mixed? They are dynamic lists as they are built from defined tables. In the Name Manager these are their expressions: lstContactID=bdContacts[ContactID] and lstPlanningID=tblPlanningIDs[PlanningID]
- Other issues unforeseen.
I came up with this validation data sentence to look up the entry in both lists:
It seems to be working but now I have to change some INDEX&MATCH formulas that were using this code to lookup in both tables.
=IFERROR(IF(MATCH(B22;lstContactID;0);TRUE;IF(MATCH(B22;lstPlanningID;0);TRUE;FALSE));FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks