Assignment 22 Lookup Function related assignment Lookup detail by the course name

 

Assignment 22

Lookup Function related assignment

Lookup detail by the course name

Function used

IFERROR :- Iferror function manage error in formula and calculation. Ifarror check a formula and if it evaluates to an error, returns another values you specify. otherwise return the result of the formula.

VLOOKUP :- This function use to when you need to find detail in a table or a range by row.

LEFT :- Left function extract a given number of character from left side.

RIGHT :- This function extract a given number of characters from the right side of a supplied text string.

COLUMN :- The excel column function return the column number for a reference.

Function use in that cells

=IFERROR(VLOOKUP(LEFT($D$6,4)&$D$20&RIGHT($D$6,8),$D$6:$G$10,COLUMNS($D$6:E6),FALSE),"Please insert course name")

IFERROR :- This function returns a custom result when a formula generate an error.

COLUMNS:- this function returns the columns number of the given cell reference.

LEFT($D$6,4) :- this is extract a given number of character from left side

RIGHT($D$6,8) :- cell address of Roll no. field column

$D$20 :- cell address of course field column.

Note

Print the student detail by course name which inside the roll number.