File AutoSave Paste Clipboard 1 X VLOOKUP 2 A Off Home 3 Teen ID 4 P20-35 5 P20-13 6 P20-30 7 P20-38 8 P20-56 9 P20-49 10 P20-41 11 P20-19 12 P20-43 13 P20-59 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 12 Calibri Insert Page Layout BIU. B 1 Font 11 First Name Martin Anna Reggie Paula Julio Tom William Aaron Kiara Marc A C Formulas =VLOOKUP(D5) D Teen-Dog Matchups March 2020 Task Instructions Last Name Program Code Brigitta Morante Anderson Leonard Morante Davison Reese Herbert Gardner Harrison Data Paws Assisting Today's Youth TD1 P1 SD1 P1 TD1 P1 GD1 P1 SD1 TD1 Alignment ce Wrap Text Review Merge & Center E Dog Type Therapy dog =VLOOKUP(D5) F X In cell E5, create a formula using the VLOOKUP function to determine the dog type for teen Anna Morante based on the Program Code listed in cell D5. Use range G4:H7 as the lookup table and the dog type listed in column 2 of the lookup table. Do not enter a value for the optional range_lookup argument. View N General