What is both of the VLOOKUP formulas?

You were told by your boss to design a sales report model which allows a user to see the quantity sold for a given product for a selected sales agent. See below image for the data file. Use Data Validation function to allow a user of this model that will be me when I grade your exam) to choose one sales agent from the list, and one product code (1, 2, .... 6) from the list where 1 stands for TV and 2 stands for Radio etc., and then write ONE formula (Vlookup) in B18 to search the table and find the quantity sold automatically. Do not make any changes to the original data in B3:H13. On Electronics SalesPartA worksheet: D E F G . 1 M N This row (CH) has product code 1 for TV 2 for tadio and etc. Radio 2 907 883 90 Ipod 3 70 587 244 loick TV 1 672 904 300 527 374 681 344 868 39 548 1 This data is for Question 1 2 1 Sales Agent Name/Product Code 5 Tom 5 7 Harry 8 Wendy 9 Charlene 10 Doll 11 Jami 13 Vivian 13 Christina 14 15 16 Sales Agent 17 Product Code 18. Quantity Sold CD 4 586 913 75 209 638 616 110 445 842 Computer Printer 5 6 500 362 589 529 914 611 145 229 523 964 800 518 433 574 898 733 903 13 745 502 282 541 10 99 631 547 669 In B18, use the same Vlookup formula from PartA but change one of the arguments in order to find the quantity sold. Hint: One argument in Vlookup will be replaced by a nested if statement to generate a proper number in order to search the table to find the quantity sold