Administration and Executive AssistantTier 345 minintermediate

INDEX and MATCH

Look up in any direction without rearranging a shared table.

What you will learn

• Find a row position with MATCH and an exact match type of 0
• Return a value from any column with INDEX
• Look up a value to the left of the key column
• Keep the INDEX and MATCH ranges aligned row for row

Excel skills

INDEX, MATCH · Position-Based Lookups

The task

Fifteen access-card requests came in with only Employee IDs. Fill in each person's full name and extension from the Staff tab. The Staff tab is the official directory that HR's other sheets read from, so leave its columns exactly where they are.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free