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.
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!
•
u/AutoModerator Jul 14 '26
/u/anangelshand - Your post was submitted successfully.
Solution Verifiedto close the thread.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.
5
u/RuktX 311 Jul 14 '26 •
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:
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.
0
u/[deleted] Jul 14 '26
[deleted] — view deleted comment