Originally Posted by thomas.szwed
I've added the tags for you as Arthur suggested. You aren't restricted to the number of different type of tags. All you need do is select the text of the formula and click the # icon on the message menu.
Back to your problem. You can avoid lots of IF() functions if you use INDIRECT(). Create a three column table of allowable values for C7. Put the C7 values in the first column, the range you want to use in the 2nd col. and the offset in the third column. e.g.
Name this range 'Table'
Now use the following formula