What you’re describing is called a vlookup and there are topics that explain how to do that. You can search the forums or Google vlookup Thunkable to get started.
If you have trouble after that, make sure to include as many details, screenshots, project link, etc. as possible. See this: How to ask Great Questions v2.0