FinanceTier 420 minadvanced

Two-Way Lookup Across Region and Quarter

Pull one revenue figure from a grid using both a row match (region) and a column match (quarter) at once.

What you will learn

• Write a single formula that matches on two dimensions simultaneously
• Explain why nesting two separate single-condition lookups is fragile compared to one two-way formula
• Use INDEX/MATCH or XLOOKUP to look across both a row and a column

Excel skills

INDEX/MATCH, XLOOKUP · Lookups

The task

The Revenue grid has regions down the side and quarters across the top. In C2, pull the revenue figure for Western Cape in Q3 using one formula that matches on both the region and the quarter at once.

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