Assignment Tasks Painting Use the VLOOKUP function to complete the \"Employee\"

Question

Assignment Tasks Painting Use the VLOOKUP function to complete the "Employee" column of Table 2 Table 2 as your lookup_value(s) and Table 1 as the reference table. [3 points] 2 7 . Use "Job lD" from ely run the company. Complete each task so that the formulas you use can be copied and bles. Do not name table ur lookup tables -ther keep them as referoncessn $47 10% e Difficulty Quality Time Bonus? ob Pa S Total Pay $3,089 $2,200 $4,919 NO BONUS NO BONUS NO BONUS NO BONUS NO BONUS BONUS NO BONUS NO BONUS BONUS NO BONUS NO BONUS NO BONUS NO BONUS BONUS Too Much Time GOOD JOB $2,000 $4,472 $1,974 4,056 $1,786 $2,652 1,728 $2,496 $2,100 $3,478 $447 NO NO $4,056 $2,143 $2,917 $1,728 $2,746 $2,100 $3,478 $2,448 $3,360 $2,999 S3,722 GOOD JOB Too Much Time POOR Too Much Time Too Much Time Too Much Time NO NO NO $3,360 $2,726 GOOD JOB GOOD JOB

Explanation / Answer

let the row no. in which the formula need to be applied at the first is 30 and column is C.

so formula in C30 is vlookup($b30,$b$14:$c$33,2,1)

the above function will match the value in the cell b30 in the column b14 to b33, and put the corresponding value in the second column of the table (b14:c33).

vlookup($b30,$b$14:$c$33,2,1)

b30 : lookup value i.e. job id

$b$14:$c$33 : lookup table (to select the row by matching lookup value in the first column of the table)

2 : column number from which the value has to be taken (1st column is the start of the table)

1: exact match of the lookup value.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.