You're an equity analyst flagging three holdings for a sector-rotation memo. Columns A–B hold a 12-row master mapping ticker symbols to GICS sectors. Three tickers you want classified are pre-populated in column D.
Your task:
- In column E (Sector), write an INDEX/MATCH formula that pulls each ticker's sector from the master table.
- The formula in E2 must be drag-down friendly — use absolute references on the master range so E3 and E4 don't drift.
Graded cells: E2, E3, E4.
Open this problem on a desktop to attempt it.