MS-EXCEL

In the Input Range Box enter the range of the table (on sheet 1) which contains all the names. ... 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 ... ................
................