Share via

Dependent Drop Downs

Anonymous
2022-03-14T20:51:47+00:00

I'm having a hard time with a complex dependent dropdown problem in Excel. In 'Column A' I would like the dropdown to consist of 3 separate worksheet options. 'Column B' would have a dropdown consisting of A4-A87 from the specific worksheet selected in the dropdown of 'Column A'. 'Column C' would then autofill with a value from Z4-Z87, corresponding with the A4-A87 value associated with 'Column B'. Thanks in advance for any help given!

Microsoft 365 and Office | Excel | For home | 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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-03-14T22:15:34+00:00

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2022-03-14T21:05:24+00:00

    Let's say the data validation drop-downs in column A are in A2:A50.

    Select B2:B50. B2 should be the active cell in the selection.

    Set up data validation of type List with source =INDIRECT("'"&A2&"'!A4:A87")

    Select C2:C50.

    Enter the formula

    =IFERROR(VLOOKUP(B2,INDIRECT("'"&A2&"'!A4:Z87"),26,FALSE),"")

    and confirm with Ctrl+Enter.

    Was this answer helpful?

    0 comments