For those of you that know Excel here is one of my formulas used in one of my worksheets. This formula is for getting 1 piece of information to help determine how a team plays in its conference vs another conference team. I have a couple of hundred cells per game, that are populated automatically from the statistics I download every night for each matchup. I am not a weekend bettor, and I have more hours than I care to count trying to find some sort of matrix that provides an edge.
"Amer",VLOOKUP(NCAABB2016!D2,AMER!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="ASun",VLOOKUP(NCAABB2016!D2,ASun!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="B10",VLOOKUP(NCAABB2016!D2,'Big10'!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="B12",VLOOKUP(NCAABB2016!D2,'Big12'!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="BE",VLOOKUP(NCAABB2016!D2,BE!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="BSky",VLOOKUP(NCAABB2016!D2,BSky!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="BSth",VLOOKUP(NCAABB2016!D2,BSth!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="BW",VLOOKUP(NCAABB2016!D2,BW!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="CAA",VLOOKUP(NCAABB2016!D2,CAA!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="CUSA",VLOOKUP(NCAABB2016!D2,CUSA!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="Horz",VLOOKUP(NCAABB2016!D2,Horz!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="IVY",VLOOKUP(NCAABB2016!D2,IVY!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="MAAC",VLOOKUP(NCAABB2016!D2,MAAC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="MAC",VLOOKUP(NCAABB2016!D2,MAC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="MEAC",VLOOKUP(NCAABB2016!D2,MEAC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="MVC",VLOOKUP(NCAABB2016!D2,MVC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="MWC",VLOOKUP(NCAABB2016!D2,MWC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="NEC",VLOOKUP(NCAABB2016!D2,NEC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="OVC",VLOOKUP(NCAABB2016!D2,OVC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="P12",VLOOKUP(NCAABB2016!D2,'P12'!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="Pat",VLOOKUP(NCAABB2016!D2,Pat!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="SB",VLOOKUP(NCAABB2016!D2,SB!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="SC",VLOOKUP(NCAABB2016!D2,SC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="SEC",VLOOKUP(NCAABB2016!D2,SEC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="Slnd",VLOOKUP(NCAABB2016!D2,Slnd!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="Sum",VLOOKUP(NCAABB2016!D2,Sum!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="SWAC",VLOOKUP(NCAABB2016!D2,SWAC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="WAC",VLOOKUP(NCAABB2016!D2,WAC!$A$23:$Q$38,13,FALSE),IF(Synopsis!I4="WCC",VLOOKUP(NCAABB2016!D2,WCC!$A$23:$Q$38,13,FALSE)))))))))))))))))))))))))))))))))*2,"")
|