question archive Can you solve my excel homework using vlookup, index, match, and if statement? You are a data analyst for the National Basketball Association and you are asked to prepare a checker tool for people to check on their website the historical wins performance of all 30 NBA teams from the year 2000 onwards
Can you solve my excel homework using vlookup, index, match, and if statement? You are a data analyst for the National Basketball Association and you are asked to prepare a checker tool for people to check on their website the historical wins performance of all 30 NBA teams from the year 2000 onwards
Subject:MS ExcelPrice: Bought3
Can you solve my excel homework using vlookup, index, match, and if statement?
You are a data analyst for the National Basketball Association and you are asked to prepare a checker tool for people to check on their website the historical wins performance of all 30 NBA teams from the year 2000 onwards.
Below is a raw backend data set and a team code table that will inform your checker tool. Site visitors will input the NBA team code and season that they want to check and your tool will ouput the following information:
- Start year of the season (ie. 2021 for 2021-22)
- End year of the season (ie. 2022 for 2021-22)
- Full Name (ie. Atlanta Hawks for ATL)
- Team Wins (no. of wins team had for the season. If blank, output should be ""Did Not Participate"")"
