Problem: I was reading Excel Help for fun the other day and I read about a function called INDEX. Who in their right mind would ever use =INDEX(B4:G22,2,4) to point to cell F6?
- The INDEX function seems useless.
Strategy: You will never use INDEX without using MATCH as either the second or third argument. Come back to INDEX after you see what MATCH does.