Microsoft Excel training notes - SchoolNet SA

11. Once a name has been selected from the drop down list, you want the grades for Test A, Test B and telephone details to automatically appear. To do this, you will use an Excel lookup function called VLOOKUP. This function is used to retrieve information stored in a table and when the desired value is stored elsewhere on the workbook. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download