Alternative to If Statement...

[fsuguy92]

Hey guys, I have a huge excel file that I'm trying to get to run faster and make the file size smaller. There are about 150k rows of data. One formula that I feel is really slowing this thing down is a nested if statement. Can you tell me if there's a more concise formula than the one below? Thank you!!

=IF(IFERROR(FIND("Air_Force",DUMP!A2),0)>0,"Air Force Falcons",IF(IFERROR(FIND("ASU_Retail",DUMP!A2),0)>0,"Arizona State Sun Devils",IF(IFERROR(FIND("Clemson_Retail",DUMP!A2),0)>0,"Clemson Tigers",IF(IFERROR(FIND("LSU_Retail",DUMP!A2),0)>0,"LSU Tigers",IF(IFERROR(FIND("Navy_Retail",DUMP!A2),0)>0,"Navy Midshipmen",IF(IFERROR(FIND("Oklahoma",DUMP!A2),0)>0,"Oklahoma Sooners",IF(IFERROR(FIND("Ole_Miss_Retail",DUMP!A2),0)>0,"Ole Miss Rebels",IF(IFERROR(FIND("TCU_Retail",DUMP!A2),0)>0,"TCU Horned Frogs",IF(IFERROR(FIND("Colorado_Retail",DUMP!A2),0)>0,"Colorado Buffaloes",IF(IFERROR(FIND("Houston_Retail",DUMP!A2),0)>0,"Houston Cougars",IF(IFERROR(FIND("Nebraska_Retail",DUMP!A2),0)>0,"Nebraska Huskers",IF(IFERROR(FIND("Texas_Retail",DUMP!A2),0)>0,"Texas Longhorns",""))))))))))))

 

[pgc01]

Hi

Try building an auxilliary table with the strings and use VLOOKUP().
Not only will it be quicker but also simpler to understand and modify.