On the support page of Microsoft you can find some more information about this function =VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE).
Practical Example: adding Field of Education to participant report Erasmus+
In the present export from the participant reports from Mobility Tool, there is no reference to the Field of Education. However, if you want to have the Field of Education for filtering in the tool you need to add this data object from another file. This can easily be done using the VLOOKUP functionality in Excel. However, you will need a source containing the Field of Education and an identifier of students that is also present in the participant report. The good news is that this source also exists in Mobility Tool: the export of student mobilities.
First thing you have to do is export both the participant report and the student mobilities from the Mobility tool. Then you use a unique key that is present in both the participant report (e.g. mobility ID in column B) and the mobilities (e.g. Participant ID in column N). Using the VLOOKUP function you can use the mobilities to add the Field of Education to the participant report with the following function in the participant report excel:
=VLOOKUP(B2;'[2016-1-BE02-KA103-017215_Mobilities_Export_students.xls]Sheet1'!$N$3:$Q$1099;4;false)
If all goes well, you will find the Field of Education.
Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.
|