I need a little help constructing the right function without it getting unwieldy. I have a high school football schedule I've downloaded that has around 4000 games for the entire season for about 420 teams. The problem is, it only gives me the school names on the schedule and I'm trying to add the mascot to each school name. I have a list of the unique school names and their mascots in two columns on the sheet, but I'm trying to find a way possibly with a formula to find the school name throughout the 4000 games and replace it with the concatenated school name with mascot. I can get an IF formula to work for the first schools games but it looks like I need an IF formula for each school, and 420 of those would get crazy. Here's a sample table.
School Home Visitor School Name Mascot
ACE Charter ACE Charter Crawford County ACE Charter Gryphon
ACE Charter Georgia Military College ACE Charter Adairsville Tigers
ACE Charter ACE Charter Pataula Charter Alcovy Tigers
Adairsville Adairsville Cherokee Bluff Alexander Cougars
Adairsville Rabun County Adairsville Allattoona Buccaneers
Adairsville Adairsville Cass Alpharetta Raiders
My apologies in advance for the data not being in a table. Since its my first time posting in this forum I wasn't sure how to build out the table appropriately.
Thanks!
Edit: Added formatting for table -- MrProgrammer, forum moderator |