Assignment 21 Lookup Function related assignment Sale Question

 

Assignment 21

Lookup Function related assignment

Sale Question

Function Used

SUMIF :- this function return the addition number of cells that supplied criteria.

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

Function Use in that cells

=SUMIF($E$4:$E$14,VLOOKUP($D$18,$B$3:$C$14,2,0),$F$4:$F$14)

SUMIF:- if the condition is meet it will add the range.

(2) :- Column index number.

$F$4:$F$14 :- cell range with dollar in a main table (sale).

$E$4:$E$14 :- cell range with dollar in main table (ID).

VLOOKUP :- find the detail in a table ir a range by row.

Note:-

There are 2 tables, table-1 has Salesman name and their ID and Table-2, ID and Sales. By using function you have to find the total sale of a salesman in Highlighted cell. Value must be responsible when I'll change the sales person then his or her total sale must be shown in Highlighted cell (Yellow).