File Home Insert Draw Page Layout Formulas Data Use the VLOO ID\" from Tabl 8 D4

Question

File Home Insert Draw Page Layout Formulas Data Use the VLOO ID" from Tabl 8 D41 Hours Employee Hours Worked Hourly Wage Difficulty Quality Time Bon NO BONI NO BON NO BON NO BON Jake Jake Jennifer $47 BONUS Jake Jennifer Jennifer Jake Jake NO BONIU NO BONu BONUS NO BONU NO BONU NO BONU NO BONUs BONUS BONUS Jennifer BONUS NO BONUS NO BONuS NO BONUS 61 Job ID Employee Difficulty Employee B of Jobs Total Hours $500 Jake Jennifer 46 47 Difficult."of Jobs Total Pay . $9,944 21,315 Four Js Painting Google Event Profit Past Events PivotTable Questions Type here to search

Explanation / Answer

Paste the following formula in the cell D40 and then drag it till D46

formula = vlookup ($B40, $B$16:$G35, 6, 0)

$B40 - lookup value

$B$16:$G35 : lookup table with first column as job ID to be matched from the lookup value and last column (6th column of the defined table) as difficulty value

6 : 6th column of the table defined in the above step for difficulty value

0 - exact match of Job ID

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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