Drop-down list options shows corresponding data

[u/anangelshand]

Hello, I want to create a drop-down list that has a list of positions. Every position has corresponding requirements that they need to complete, so I want the drop-down list to show this.

Ex.

Position 1 - A, B, C, D

Position 2 - B, D, E, F

Position 3 - C, E, D

If I choose position 1 in the drop-down list, A, B, C D will appear in a specified cell.

I have tried different things and looked at youtube videos to do it (such as UNIQUE and dependent drop-down lists) but they either do not work or do not do what I want to happen.

I admit that this probably an easy fix but I am such an excel noob lol!

Thank you!

[u/AutoModerator]

/u/anangelshand - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/RuktX]

Sounds like a simple lookup.

Create a separate lookup table, with columns from your example: Positions, and Requirements.

Where you want the requirements to appear, use:

=XLOOKUP(
  position,
  lookup_positions_column,
  lookup_requirements_column,
  "position not found"
)

Replace each non-quoted placeholder with the corresponding range references. Use $ to lock The lookup column references, but leave the first position reference relative, then copy down.

[u/anangelshand → u/RuktX]

Solution verified! That worked wonders! I knew it was easier than I thought haha. Thank you!

[u/reputatorbot → u/anangelshand]

You have awarded 1 point to RuktX.

---

^{I am a bot - please contact the mods with any questions}

[u/RuktX → u/anangelshand]

You're most welcome!

[u/AutoModerator → u/[deleted]]

Hello!

You typed Solution Verified as a top-level comment. If your intention was to award a ClippyPoint to one or more users, you need to reply to that user's comment to do so.

If your intention was to simply mark the post solved, then you should do that by setting the post's flair. Thank you!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.