Formula that reads off a different column every week (without Indirect)

[ZealotAssasin]

Hi,

I have a spreadsheet with weekly sales of an item going across columns like below:

Item# Week1Sales Week2Sales Week3Sales FORMULA

I'd like the formula to reference the corresponding week depending on what week I've input in another part of the formula. I've incorporated this with an Indirect, but since I have so many of these formulas, the file is running extremely slowly when calculating. Does anyone have any other suggestions?

Thanks

[Pete_UK]

INDIRECT is a volatile function and so can often cause your workbook to slow down considerably, but you can avoid it by using INDEX instead, and this is not volatile. Take a look at XL Help for details of how you can use it to return cell (or range) references.

Hope this helps.

Pete

[ZealotAssasin]

I have now converted the Indirect into an Index/Match function (matching both column and row). However I am not sure if this will improve performance? Are volatile functions that much slower?