This is the situation: First cell (A2) has a drop down menu with 4 items... Those items are listed as Complaint, Compliment, Question and Suggestion. Second cell (B2) has an indirect drop down menu depending on what it is selected in the first cell... For example in A2 if I select Complaint in cell B2 anything corresponding for Complaints a list appears... Now let's say cell A2 is Complaint and cell B2 is Formulation... Now in cell C2 anything with regarding with Formulation a list drops down.... Now I had set everything with data validation and manage name... here is my issue... Some names in cell B2 overlaps with the 4 main selections which makes it difficult for me to drop down a different list... For example the word "Formulation" is listed for Complaint, Compliment and Question... Now the list is different in regards to those three items when I have to go into cell C2... So if I want Compliment(A2), Formulation (B2), in C2, I get the list from the complaints and not for compliments.... So I need a function that lists a list for Formulation selected in cell B2, but relates to cell A2.... I know I'm listing the function out wrong because I'm getting blanks cell for cell C2... I know it needs a INDIRECT Function and either a combo of with IF function or Vlookup function or something different... I just don't know how to set it up. Please assist! Many thanks!
Data Validation using same key words but different list
-
-
-
Re: Data Validation using same key words but different list see thread 4more details
You could name the source lists for column C based on both A and B, so you would have named ranges would be ComplaintFormulation and ComplimentFormulation. The list source for C could be =INDIRECT(A1&B1)
-
Re: Data Validation using same key words but different list see thread 4more details
Thank you mikerickson! That help the situation. I had a prior INDIRECT formula and didn't think of using that instead. I have a question for you. How would you combine these two INDIRECT Formulas.... =INDIRECT(SUBSTITUTE(A2," ","_")) and the one you provided, =INDIRECT(A1&B1). Just out of curiousity. Many Thanks again!
-
Re: Data Validation using same key words but different list see thread 4more details
Perhaps
=INDIRECT(SUBSTITUTE(A1&B1," ","_"))
-
Re: Data Validation using same key words but different list see thread 4more details
THANK YOU! You have been beyond helpful!
-
-
Re: Data Validation using same key words but different list
GARCIAM10,
Please do not include comments such as "see thread 4 more details" as part of the thread title.
Members are going to read the thread without the need to be informed to do so.Most importantly, though, thread titles are used in searching the forum and unnecessary text in the title dilutes the search results.
Accurate, well-written titles will yield more relevant results.I've revised your title to remove the commentary.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!