Easiest way to have a dropdown based on 2 conditions

[FJPunisher]

Hello Experts,

I am looking for help on below, I am sure this is possible but can’t find a most efficient way to do this.

• I will capture ID as text in a cell, this can be A_100, A_200, A_300, A_400, A_500 or A_600, (DONE)
• Based on that ID, I am using VB to paste the days that are associated with that ID, (DONE)
• Now based on the ID & DAY i want to show a dropdown list with up to three options. (HELP!)

In short, what is the easiest way to have dropdown list based on 2 conditions…
e.g.
IF ID = A_100 & Day = D_SUN Then Dropdown = 5.50, 6.6, 4.5

 

[kweaver]

Since you don't have FILTER, you could make these three cells (all array entry: CSE):

R3:

=INDEX($K$3:$K$38,MAX(ROW($3:$38)*($P$1&$Q$1=$G$3:$G$38&$I$3:$I$38))-(ROW())-1)

R4:

=INDEX($K$3:$K$38,MAX(ROW($3:$38)*($P$1&$Q$1=$G$3:$G$38&$I$3:$I$38))-(ROW())-1)

R5:

=INDEX($K$3:$K$38,MAX(ROW($3:$38)*($P$1&$Q$1=$G$3:$G$38&$I$3:$I$38))-(ROW())-2)

and the source for data validation: =R3:R5

I think that'll work.