excel help please!

2 In cell G19, use an Excel function to lookup the category for each film that was rented in the rental table The category for each film is listed in the film table. Fill the formula down so that each film_id correctly matches its film category. Add a total row to the film tau. Update the total row to show the average film_length B C. D E F G 13 14 15 16 17 Rental table Cagetory 18 19 20 21 22 23 24 25 26 27 28 29 30 31 customer_id rental_id rental_date 5 13209 1/3/20 9 15813 5/31/20 11 11646 3/8/20 14 13780 3/24/20 15 13968 4/18/20 15 13798 3/12/20 21 14933 1/25/20 22 12222 2/18/20 23 15532 1/24/20 28 12938 2/21/20 29 15577 2/23/20 33 12277 2/20/20 41 15875 1/21/20 42 15407 2/6/20 42 13351 3/13/20 43 15745 1/3/20 43 15644 6/16/20 44 13428 6/12/20 52 12001 1/24/20 53 11657 4/7/20 53 14137 5/2/20 56 15714 4/18/20 58 15326 4/18/20 60 12489 6/21/20 60 14741 2/5/20 64 13333 6/19/20 69 11995 5/15/20 73 13108 2/15/20 75 13534 5/1/20 15191 6/9/20 75 14488 417/20 film_id 345 219 105 385 812 116 264 861 236 869 118 90 789 733 897 600 689 21 902 667 510 451 730 86 133 243 862 792 32 rental_rate 0.99 4.99 0.99 4.99 0.99 2.99 2.99 4.99 2.99 2.99 0.99 0.99 2.99 0.99 4.99 0.99 2.99 4.99 4.99 2.99 4.99 4.99 0.99 4.99 4.99 4.99 0.99 2.99 2.99 2.99 2.99 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 542 75 806 914 AQ Advanced Text to Columns H ca An M Filmtable Cagetory im id 14 15 16 17 18 tal rate 19 0.99 20 4.99 21 0.99 22 4.99 23 0.99 24 2.99 25 2.99 26 99 27 2.99 28 2.99 29 0.99 30 0.99 31 2.99 32 0.99 33 1.99 14 0.99 35 2.99 36 4.99 37 4.99 38 2.99 39 4.99 40 4.99 41 0.99 42 4.99 434.99 44 1.99 45 0.99 46 2.99 47 2.99 4B 2.99 49 2.99 50 2.99 title rating 19 AMADEUS HOLY PG 21 AMERICAN CIRCUS 67 BERETS AGENT PG-13 105 BULL SHAWSHANK NC-17 205 DANCES NONE NC-17 229 DEVIL DESIRE R 253 DRIFTER COMMANDMENT PG-13 375 GRAIL FRANKENSTEN NC-17 330 LORD ARIZONA PG-13 542 LUST LOCK G 574 MONIGHT WESTWARD G 586 MOCKINGBIRD HOLLYWOIPG 823 SOUTH WAT R 869 SUSPECTS QUILLS PG 982/WOMEN DORADO R 118 CANYON STOCK R 160 CLUB GRAFFITI PG-13 243 DOORS PRESIDENT NC-17 300 FALCON VOLUME PG-13 314 FIGHT JAWBREAKER R 326 FLYING HOOK NC-17 330 FORRESTER COMANCHERO NC-17 461 SECTS STONE NC-12 464 INTENTIONS EMPIRE PG-13 489 NUDGLER HAROLY 06-13 510LAWLESS WON 696 PRIDE ALAMO NC-17 SOS MEERLESS MONSOON o 820 SONS INTERVIEW NC-17 886 THEORY MERMAID PG-3 892 TITANDCROONDOCK 191 CROOKED FROGNEN PG-13 special features capes film lengd Commentaries Deleted Scene Behind the Action Commentaries Behind the Scenes 113 Action 129 Deleted Scenes Action Deleted Scenes 77 Action 925 Trators. Commentaries, Deleted Scenes Be Action 58 Trailer Behind the Scenes Action 32 Trailer.Behind the Scenes Action Commentaria Deleted Scenes Behind the SA 35 Trailers Action 100 Trailers. Commentaries Behind the Scenes Action 52 Teleted Scene Action 36 Behind the Scenes Action so Commentaries. Behind the scenes Actie 14 Trailers Action 47 Deleted Scenes Behind the Scenes Action 126 Traveleted Scenes RS Trailers, Deleted Scenes Animation Traders. Comentaries. Deleted Scenes Bohi Animation Commentaries Behind the Scenes Animation 100 Trailer Comments Deleted Scene Bimation 91 Trailer Command the scene Animation 90 Trailer. Behind the Scenes Animation 112 trond the Scenes Antian Trailer Bohind the con Mrination 209 Trailers.com A Oldehind the scene 11 Deleted Scenes A 110 Daler Deleted Scene behind the Scene Animation Commentare led the Scene Animation 184 Deted Scents Behind the Scenes Animation 104 Tramid Senec Come Delted scene had the Children 10