Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2020, 04:28 AM
Stuart_Brennan Stuart_Brennan is offline Drop down list conditioning on text with wildcards Windows 10 Drop down list conditioning on text with wildcards Office 2019
Novice
Drop down list conditioning on text with wildcards
 
Join Date: Dec 2020
Posts: 2
Stuart_Brennan is on a distinguished road
Question Drop down list conditioning on text with wildcards

Hi,




I have the following problem that I am trying to resolve. I have a data set consisting of multiple columns but for ease lets just use 2 columns A & B. Both columns contain text in each cell that is comprised of multiple words.


I want to be able to type a value into cell D1 that in effect is being used as a search term. In cell E1, I then want a dropdown list that contains all the values from column B where the adjacent cell in column A contains the search term.


I have tried index, match formula within the data validation list formula but the validation list only contains the first matching value


The formula I have within the data validation - list - source field is :


=INDEX('All stock'!$A:$B,MATCH("*"&D1&"*",'All stock'!B:B,0),2)


Can anyone help ??


Thank you


Stuart
Reply With Quote
  #2  
Old 12-02-2020, 06:01 AM
ArviLaanemets ArviLaanemets is offline Drop down list conditioning on text with wildcards Windows 8 Drop down list conditioning on text with wildcards Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Is something like this, you want?
Attached Files
File Type: xlsx DataValidationListFromSearch.xlsx (12.0 KB, 9 views)
Reply With Quote
  #3  
Old 12-02-2020, 06:45 AM
p45cal's Avatar
p45cal p45cal is offline Drop down list conditioning on text with wildcards Windows 10 Drop down list conditioning on text with wildcards Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Office 365?
See attached
Attached Files
File Type: xlsx msofficeforums46090.xlsx (10.8 KB, 9 views)
Reply With Quote
  #4  
Old 12-02-2020, 10:12 AM
Stuart_Brennan Stuart_Brennan is offline Drop down list conditioning on text with wildcards Windows 10 Drop down list conditioning on text with wildcards Office 2019
Novice
Drop down list conditioning on text with wildcards
 
Join Date: Dec 2020
Posts: 2
Stuart_Brennan is on a distinguished road
Default

Thank you to both of you for responding.


@ArviLaanemets - your solution worked brilliantly. Thank you so much.


Stuart
Reply With Quote
Reply

Tags
index and match, list, validation

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down list conditioning on text with wildcards Help with populating text from drop down list s0nginmyheart Word VBA 2 02-07-2019 06:31 PM
VBA coding for multiple drop-down lists to populate a text box for each list yeatropulo Word VBA 14 11-11-2015 01:08 PM
Auto Text Drop Down List AJohn403 Word 3 05-01-2015 05:00 AM
Drop down list conditioning on text with wildcards DRop down list within text of If statement sbarron76 Mail Merge 2 05-03-2013 05:00 AM
Drop down list conditioning on text with wildcards Populating ComboBox or Drop Down list with contents of a text field Billy_McSkintos Word VBA 1 09-13-2011 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft