Hi
I have some cases where: IF criteria1 and criteria2 are met, I have 2 values.
Match function returns the first available value. While I expect it to be in a validation list so that user selects what he wants.
any idea?
thx
Hi
I have some cases where: IF criteria1 and criteria2 are met, I have 2 values.
Match function returns the first available value. While I expect it to be in a validation list so that user selects what he wants.
any idea?
thx
You need to set up a unique code for each record that meets the criteria - if this code is a simple sequence 1, 2, 3, etc., then it is quite easy to retrieve the appropriate data.
Attach a sample workbook (the FAQ describes how) so we can see how your data is laid out. Show before/after sheets to make it clearer.
Hope this helps.
Pete
Hi
I am attaching a sample file. I want to build a validation list in Parameter4.
Parameter4 depends on the 3 other parameters:
if Parameter 2 is set to v, Parameter4 should display the list Parameter4_1 (easy stuff)
if Parameter 2 is set to p or c, Parameter4 should display values in Parameter4_2 that match with the values existing in Parameter1 and Paramter3. I set a table with all possible values for Parameter4 depending on Parameter1 and Parameter3. So for example - Assuming Parameter 2 equals p or c - if user selects Parameter1=a and Parameter 3 = 8, Parameter4 should display a list showing 24 and 48. If user selects Parameter1=a and Paramter3=12, the only option left in Parameter4 is 24 (list of 1 value only)
if Parameter1 OR parameter2 OR paramter3 are not selected (value = Select), Paramter 4 should display something like Not Available.
It is a question of creating a "dynamic" validation list based on 2 other values. Then, use either list Parameter4_1 or this dynamic list based on Parameter2. Otherwise, just use Not Available. I am stuck with the first part (creating dynamic list based on 2 other values). I tried to use MATCH and INDEX but I only got 1 value.
any idea please?sample.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks