Retrieving with INDEX

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 18 of 28.

For a single column, INDEX(range, position) returns the value at a one-based position. It complements MATCH: MATCH finds a position, and INDEX retrieves the value at a position.

B2 contains Pad, B3 contains Pen, B4 contains Clip, E2 contains 2.

Example: =INDEX(B2:B4,E2).

Position two selects the second item of the range: Pen.

INDEX returns a value at a one-based position in the chosen range.

The practice sheet highlights cells where you should enter formulas. The same formulas must work when the tests replace the input data.

Challenge

Easy

Product names are in B2:B4; the selected one-based position from 1 through 3 is in E2. Return the selected name in F2.

Enter formulas in the highlighted output cells: F2. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.

Try it yourself

Sheet1