Share via

Show result based off of 2 (independant) drop downs

Anonymous
2025-02-24T15:20:53+00:00

Hi All,

I have two drop down lists (Store) and (Day) these are not dependant on each other but I need the third cell to display the result of what is selected in those two drop down lists. For Example if Cell A displays London in the Store drop down and Cell B displays Monday in the Day drop down the cell C will show the Value from my range. If I were to change the Store to Birmingham then the Value in Cell C will automatically update to show the Value from my range as Birmingham's Monday result as opposed to London's and so on.

I have tried searching but everything I can find is based off of Dependant Drop Downs whereas this is two independant lists that I want to find a result from.

Any help would be much appreciated.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Rich~M 20,370 Reputation points Volunteer Moderator
2025-02-25T20:42:46+00:00

The layout is a problem for what you are wanting to do because there is no data to match with in the second column of each of the merged cells, i.e. Columns C, E, G, etc. Also, XLOOKUP won't retrieve data from two columns in a cross-lookup.

I have modified the layout in the screenshot below to give data that the formula can look for to retrieve the desired data based on the two dropdown selections. It will require that the day is in every column in Row 2 to identify that those columns should be included in the formula result.

I don't know where your dropdown criteria cells are located, so, I put them in Q4 and R4. Adjust those cell references to the correct location in your workbook. The formula is in S4 and will spill the "1 in" results into T4. Here is the formula.

=FILTER(FILTER(B4:O23,A4:A23=Q4),B2:O2=R4)

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-25T13:57:59+00:00

    Thank you so much for your reply. What you put makes sense and I have tried it but it doesn't work I think it is my layout that is causing the issue, but I am not at a level on Excel to know for sure. I have posted a screen shot below hopefully it helps find an answer to what I am looking for (if there is one)

    What I would like is for there to be on a seperate sheet, one dropdown that has the store name, one drop down that has the Day and then two additional cells that populate the Sale number and the 1in number based on the selections of the drop downs.

    Thanks again for the support

    Was this answer helpful?

    0 comments
  2. Ashish Mathur 102K Reputation points Volunteer Moderator
    2025-02-25T01:49:43+00:00

    Hi,

    Share data in a format that can be pasted in an MS Excel file. Show the expected result.

    Was this answer helpful?

    0 comments
  3. Rich~M 20,370 Reputation points Volunteer Moderator
    2025-02-24T18:17:18+00:00

    This depends completely on how your data is laid out. I took a guess at how it might be. Here is my sample data.

    Here is the formula that can be used to get the correct data for the two criteria in the dropdown cells, A8 and B8, as laid out in the sample. The formula is shown in C8 below.

    =XLOOKUP(A8,A2:A3,XLOOKUP(B8,B1:F1,B2:F3))

    The ranges and the location of your dropdown cells will obviously need to be adjusted to match your data and layout. Hopefully this will give some direction. Reply with more details and a screenshot of how your data is laid out with any sensitive data removed if you need additional assistance.

    Was this answer helpful?

    0 comments