Page 177 - Ms Excel Note and Workbook
P. 177

MICROSOFT EXCEL NOTE AND WORKBOOK


               6.      Using VLOOKUP formula, find the matches “MATH MARK” in cell C19, “PHYSICS
                       MARK” in cell C20, and “CHEMISTRY MARK” in cell C21,  when user choose the
                       STUDENT NAME at cell C18. Use the formula:

                              For MATH MARK:
                              =VLOOKUP(C18,B4:I12,2,FALSE)

                              For PHYSICS MARK:

                              =VLOOKUP(C18,B4:I12,4,FALSE)


                              For CHEMISTRY MARK:
                              =VLOOKUP(C18,B4:I12,6,FALSE)












































                                                                                              168 | P a g e
   172   173   174   175   176   177   178   179