I need help with using the HLOOKUP function for this question.

In addition to the school-based financial aid, the department of finance and marketing have their own extra budget to offer financial aid to the students based on their GMAT score. Write a function in cell I2 that returns not qualified if the GMAT score of the applicants is below 600 or they are from Information Systems department. Otherwise, the function should assign the appropriate scholarship to the applicants of each department based on the GMAT score. (20 points)

B 5-2 = Home Insat Page Layout Formula View Tell me what you want to do Define Name. ? A Q e Live in Formale Namu AutoSum Recently Financial Logical Tod Dule & Luckup & Muth & More Used- Function - Time Reference Ing Functions Manager Create from Selection Function Library Defined Narves F24 be -AVERAGFIFS(02:021,C2:C21,"Marketing") A A R D F Years of Industry 1 Applicant id GPA Department Information Systems Origin Domestic International GMAT score 507 experience 4 2 1 3 2 85 553 10 4 90 645 10 Demastic International 3 95 741 9 6 International Marketing Finance Marketing Finance Marketing Finance Marketing 92 650) 7 International 607 8 International 77 619 9 0 International 80 720 10 International Finance 97 656 11 International Information Systems 85 611 12 International 90 Finance Marketing 13 Domestic 90 678 14 Domestic Information Systems 36 700 15 Domestit0 87 Marketing Finance 12 16 Domestic 627 = 17 Information Systems 77 635 Domestic International 10 18 83 631 Finance Marketing 19 Domestic 88 670 20 29 590 Demastic Information Systems Marketing 21 Domestic 91 23 3 24 75 26 27 78 20 30 31 82 33 34 B3 30 37 Ready AutoSave File fx > 3 4 3 6 7 9 10 11 12 13 14 1.5 10 17 18 19 20 Question 1-5 Olype here to search Dal Question 6-7 Question 8 J Revi 7 87.875 Help 2 2 7 8 2 4 6 5 2 4 = 4 10 5 8 4 7 Excel part 2 Assignment - Excel Calculate Now Trace Procedents Show Formulas Trace Dependents Checking- Remove Are Evaluare Formuls Formula Auditing 69 Watch Calculation Calculate Sheet Window Options- - Calculation H Experience Level School based Finacial aid Department based Finacial aid #N/A not applicable Medium Very High Vary High Very High Low Low Very High Very High Low Medium Very High Very High Low Medium Medium Very High Very High Very High Medium Very High @ E K L GPA Sore.... GMAT Score Department of Finance finacial sid Department of Marketing finacial aid---> Domestic or International- M D Brandon Jones - X N P Q R SA Hlook 1 School Based Finacial aid Look up 80 85 50 50% 80% 100% 700 Hlackup 2 Department Based Finacial aid GOD 030 $1,000 $5,000 $2,000 $4,000 $10,000 $8.000 A 400 10006 3:35 PM 12/1/2017