#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Is something like this, you want?
|
#3
|
||||
|
||||
Office 365?
See attached |
#4
|
|||
|
|||
Thank you to both of you for responding.
@ArviLaanemets - your solution worked brilliantly. Thank you so much. Stuart |
Tags |
index and match, list, validation |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 within text of If statement | sbarron76 | Mail Merge | 2 | 05-03-2013 05:00 AM |
Populating ComboBox or Drop Down list with contents of a text field | Billy_McSkintos | Word VBA | 1 | 09-13-2011 05:50 AM |