Hi, please send the answer in excel file format, I just badly need your help. Please see the two photo below. Thank you so much

?

P4. Using only the "VLOOKUP" function, transfer all of the data from the table below into the "Individual Sales" table. Individual Sales Rank Name Sales Team Susan 5 red Thomas 7 red Lynn 2 blue 5 Sean 6 blue Jerry 20 yellow 2 George 12 red 10 Elaine 1 red 7 Delores 4 blue 4 Tony 9 yellow 3 Art 12 blue Individual Sales Rank Name Sales Team 2 4 5 6 7 8 10A B C D E F G H 1 Using only the "SUMIF" function, complete the "Team Sales." 2 Individual sales 3 Rank Name Sales Team Rank Name Sales Team 6 Susan 5 red 5 8 Thomas 7 red 6 9 Lynn 2 blue 7 5 Sean 6 blue Jerry 20 yellow g 2 George 12 red 10 10 Elaine 1 red 11 7 Delores 4 blue 12 Tony 9 yellow 13 3 Art 12 blue