To use either the OFFSET or INDEX functions in Excel, the following tips can be helpful:

t
1. Understand the syntax for each function
t
2. Learn how to use mixed references in order to make them more flexible
t
3. Work with relative and absolute references to make formulas that will adjust when they are copied
t
4. Be sure to use a range lock correctly so the formula will work in all scenarios