We will practice this in class - its very useful.

example spreadsheet is below

if you just put a box around the first two rows of any column (b,c,d,e,f) and drag the magic little dot down for completeness, it does the right logic

Example spreadsheet

http://www.cpearson.com/excel/indirect.htm

Week 4