Ch 3. part 3 - C hapter 3: Excel Functions, Pa r t 3 (of 3)...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Functions, Part 3 (of 3) Chapter Skills for Chapter 3, Part 3 Use the VLOOKUP function to return a match based on a numeric range. Use the VLOOKUP function to return an exact match. Use the VLOOKUP function to return a match based on an alphabetic text range. Chapter Vocabulary for Chapter 3, Part 3 VLOOKUP function (know its arguments, including the last argument which is optional). o lookup value o lookup table (range) o column index o range match exact match #VALUE! (know what causes this error value) Chapter Demonstration 7: Use the VLOOKUP Function to Find a Numeric Range Match Continue with the FunctionsPractice.xlsx workbook from earlier chapter demonstrations. Assign a salary grade (A, B, C, etc.) to each employee based on a defined range of salary values for each salary grade. 1. Select the Salary Grade table in range A17:B25 and drag it with the mouse to the new range M17:N25. (We are moving this table for the convenience of seeing it in the same view with the Salary Grade column which will use the lookup table.) 2. Into the Salary Grade column, insert a formula that will enter the correct salary grade according to the salary grade table on the worksheet. The salary ranges in the salary grade table represent the lowest salary (lower bound) in the range. =VLOOKUP(K2,M18:N25,2)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Ch 3. part 3 - C hapter 3: Excel Functions, Pa r t 3 (of 3)...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online