3. Terrible Equation. Trying to use index match?

Terrible Equation. Trying to use index match?

=IFERROR(
    IF(

         B19 = "Receptions",          VLOOKUP(              $A$14,              '2015 Stats'!$A$1:$N$301,              9,              FALSE         ),          IF(              B19 = "Pass Yards",              VLOOKUP(                  $A$14,                  '2015 Stats'!$A$1:$N$301,                  4,                  FALSE              ),              IF(                  B19 = "Pass TD",                  VLOOKUP(                      $A$14,                      '2015 Stats'!$A$1:$N$301,                      5,                      FALSE                  ),                  IF(                      B19 = "Int",                      VLOOKUP(                          $A$14,                          '2015 Stats'!$A$1:$N$301,                          6,                          FALSE                      ),                      IF(                          B19 = "Rush Yds",                          VLOOKUP(                              $A$14,                              '2015 Stats'!$A$1:$N$301,                              7,                              FALSE                          ),                          IF(                              B19 = "Rush TD",                              VLOOKUP(                                  $A$14,                                  '2015 Stats'!$A$1:$N$301,                                  8,                                  FALSE                              ),                              IF(                                  B19 = "Rec Yds",                                  VLOOKUP(                                      $A$14,                                      '2015 Stats'!$A$1:$N$301,                                      10,                                      FALSE                                  ),                                  IF(                                      B19 = "Rec TD",                                      VLOOKUP(                                          $A$14,                                          '2015 Stats'!$A$1:$N$301,                                          11,                                          FALSE                                      ),                                      IF(                                          B19 = "Fumbles",                                          VLOOKUP(                                              $A$14,                                              '2015 Stats'!$A$1:$N$301,                                              12,                                              FALSE                                          ),                                          IF(                                              B19 = "Points P/G",                                              VLOOKUP(                                                  $A$14,                                                  '2015 Stats'!$A$1:$N$301,                                                  13,                                                  FALSE                                              ),                                              IF(                                                  B19 = "Fantasy Year",                                                  VLOOKUP(                                                      $A$14,                                                      '2015 Stats'!$A$1:$N$301,                                                      14,                                                      FALSE                                                  ),                                                  "No"                                              )                                          )                                      )                                  )                              )                          )                      )                  )              )          )

/r/excel Thread Parent
Previous
Next

Recently removed from /r/excel

Excel Solver either keeps changing the answer or gives the same wrong answer. How do you get rid of the blasted format painter icon that obscures text - Excel/Mac 16.72 - Microsoft 365 What’s the easiest way to share an excel document with Reddit? How do I set a character max and format? Calculate total number of years months and days from already calculated set of individual results displayed as years months and days. Dynamic Scheduling Based on Rotation and Start Day Is there a way to turn my date range in text form to a two-column number form date range? Is there any way to freeze the top row by default or otherwise save the state of frozen cells? Why is my rounding bugging? Vlookup issue with value that exists completing the excel exposure Complicated MOD function that possibly might just be algebra.. Comparing two workbooks for differences Microsoft Money for Excel released today How do I insert a number of blank rows between every row of data, and then copy each row down?

More Random Comments

Harassment of girl gamers - I've never experienced it, or seen it happen. On the lack of innovation in software Why I left Nash Finch demolition on Blairs Ferry makes way for more retail I'm a sheltered Christian and I never knew so many athiests existed. This page blows my mind and I'm not sure how I feel. I [16F] lost my virginity. I also lost my best friend [16F], boyfriend [17M] and my job. What the hell do I do?? transition questions, not sure ill ever be able to tell my family... Recruitment Workshop A professional programmer recently joined my amateur game project. Didn't work out. Lessons learned. Nash Finch demolition on Blairs Ferry makes way for more retail TIL of a Dutch nursing home which provides free housing to college students in return for being good neighbors, interacting with older residents, attending parties, etc to ward off loneliness and depression common in the elderly. [Question] What do you guys think is a good kdr? Discuss your dailies. On the lack of innovation in software Nash Finch demolition on Blairs Ferry makes way for more retail