Page 1 of 1
below, the VLOOKUP formula is to be used in cell C2 under Course Name to automatically display the name of the course us
Posted: Fri Jul 08, 2022 6:39 am
by answerhappygod
- Below The Vlookup Formula Is To Be Used In Cell C2 Under Course Name To Automatically Display The Name Of The Course Us 1 (54.92 KiB) Viewed 38 times
below, the VLOOKUP formula is to be used in cell C2 under Course Name to automatically display the name of the course using the lookup table shown in the cells E2:H5. The formula will then be copied down to the cells below. A 1 Student Name 2 Jerry 3 George 4 Kramer 5 Elaine 6 Newman 7 Larry B Course ID Course Name MNG2100 SOC1100 MNG2200 MNG2100 ENG1205 MNG2200 lookup_value table_array SES2 SHS5 # col_index_num 4 range_lookup 82 D รท E G Course ID Semester Offered by MNG2100 1 SEBI Faculty of Education and Humanities ENG1205 SOC1100 MNG2200 2 1 2 The format of the VLOOKUP function is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) You are asked to identify the arguments for the formula using the drop down boxes below. H Course Name Computer Studies I Introduction to English Faculty of Social Sciences Introduction to Sociology Information Systems SEBI 4