So I have one sheet with team multiple matchups for the week. This is written as "Ohio State at Wisconsin". I have a table setup with team names in Column A and the ranking in Column B. What I want to do is look up if ANY team in the matchup cell is found in the table then return the ranking found in that table. The text criteria is dynamic because each matchup will have different teams.

Screenshot.png