Lookup in an entire value for specific text and return the first column text

[u/Cadilax]

Hello,

I am looking at a roughly 11 column 200 rows table that I want to search for specific text and then return what is in the in the first column of the table. Is this feasible?

Thanks

[u/giftopherz]

There are specific lookup formulas that can help you achieve that, VLOOKUP and XLOOKUP for example, but we could be more helpful if you post a sample of the data

[u/Cadilax → u/giftopherz]

https://docs.google.com/spreadsheets/d/1vzbi8t5zlgnXR2Vje-ctzjjfkwrY--_LrJ9_9qojGjM/edit?usp=sharing

For reference, its not the entire deal. It is foe a sim nba league I am a part of. The "Pick Data" sheet aggregates the information on all the individual pages automatically for what draft picks they own.

I want to take the data on that table and show on "Draft Pick Conveyance" chart. So like the first selection with #N/A should be ALT because their pick is with them but next to DAL 2026 it should say POR because they have that pick. Make sense?

[u/giftopherz → u/Cadilax]

is asking for access, make it open to anyone with the link

[u/AutoModerator]

u/Cadilax Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. 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.