Assignment 20 Lookup Function related assignment Lookup value Dashboard

 

Assignment 20

Lookup Function related assignment

Lookup value Dashboard

Function Used

VLOOKUP :- The vlookup function is used fo, when you need to find thing in a table or a range by row.

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

Function use in that

=VLOOKUP(VLOOKUP($E$12,$G$4:$H$8,2,0),$B$4:$E$8,COLUMN(B4),0)

VLOOKUP:- find things in a table or a range by row.

Column :- this function return the column number.

(2):- column index number.

(B4) cell address of name column.

Note :- then drag it in right side of column.

Note :-

In the Dashboard table the Salary, Department and Bonus should be change whenever I select different ID of Employee. The ID is in Table -2 and other details in Table-1. You should insert Function in Highlighted cell by yellow color to print the different fields according to the ID.