{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch 3. part 3

# Ch 3. part 3 - C hapter 3 Excel Functions Pa r t 3(of 3...

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

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)

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online