I am working on a sports schedule worksheet. I want to use a variable so I
can change the schedule from year to year without having to reprogram it.

What I want to do is create a formula where it checks the full team name in
D5 and compares it to the master list of team names listed in A1:A32, then
take the corresponding cell B1:B32 (the adjacent list of shortened names) to
enter the results in E5.

If I can get an example with and without a macro, I'd appreciate it.