$1.$ In cell J$6,$ enter a VLOOKUP function that will lookup the MovieID value in the leftmost column of the MovieTitles named range and return the movie name from the second column. Incorporate an IFERROR function so that if there is no MovieID, the function returns a blank.

$2.$ In cell K$6,$ enter a VLOOKUP function that will lookup the MovieID value in the leftmost column of the MovieRatings named range and return the movie rating from the second column. Incorporate an IFERROR function so that if there is no MovieID, the function returns a blank. Copy the formula down through cell K$35.$

$3.$ In cell N$5,$ enter an INDEX function that will retrieve the name of the movie with the highest gross sales. Write the function using the INDIRECT function as the array argument and then copy the formula across to P$5.$