If the student does not have a skill level entered in the Student_Data named range, the VLOOKUP will return a value of 0. Incorporate an IF function in the formula so that if the value returned is a 0, display a blank value ("") instead, otherwise display the value returned by the VLOOKUP function.

Formula explained below

Explanation:

You have not mentioned what the Student_Data range is. But from the context, I think it's =StudentData!A3:H34.

So, use the following formula in '$F$3' of LessonData:

=IF(VLOOKUP(B3,Student_Data,8)=0,"",VLOOKUP(B3,Student_Data,8))

Then copy the above formula up to F29.

NOTE:

8 means 8th column of the 'Student_Data' table which is the 'Skilllevel' column.

a variable of array type holds a reference of object

array are commonly used in computer program to organize data so that a related set of values

array are using zero base indexing it start with 0.

all component of array have same type, two different types doesn't use in single array

if array are store 10 quantities its index value varies from 0 to 9.

it stores 1st quantity value in index value 0 and this process will same till index value 9.