Description:
You can easily create a certificate using an Excel sheet automatically by the function Vlookup
Explanation video:
Next Step:How to Split each students certificate in Separate Tab
Function explanation:
Full function written in the cell "=VLOOKUP($B$9,'Control Sheet'!$B$1:$H$26,3,0)"
- =VLOOKUP( ): to search in a certain range vertically
- $: To fix the column name and row number while dragging to other cells.
- B9: the cell containing the student's name.
- 'Control Sheet'!$B$1:$H$26: The range to search through, in the original sheet.
- 3: The number of columns need to get the value from.
- 0: To get the accuracy of the value.
Attached the sample file used in the video explanation: