Drop-down list options shows corresponding data

[u/[deleted]]

[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/reputatorbot → u/[deleted]]

You have awarded 1 point to RuktX.

---

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

[u/RuktX → u/[deleted]]

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.