Lookup specific text value and return value from adjacent cell

Hey everyone,

I'm currently trying to return a cell value based on the text from the column next to it. In the screenshot attached it shows the bettings odds of two teams playing - based on the team I'm betting for in cell F3 (CHI), I want to lookup the value and return the odds corresponding to that team (E3, 2.10). Is there a better way to set up the table in order to do this?

Thanks!

Here's one option. In G3:

=SUMIF(B3:D3,F3,C3:E3)

=INDEX(B3:F3,1,MATCH(F3,B3:E3)+1)

in G3

Thanks for the rep!

If that solved your question, please mark this thread as SOLVED.