I need to select cells in a formula that is more complex than the B5 kind of cell selection. I want to take a cell that has a number in it, and do something like x=(A1-1)*6+4 and then put that x into a cell reference like C[x] in another formula.
So the computation of x would specify the row in the cell address. What I need is for a cell's VALUE to get put into the cell address specification in a formula. I don't see any syntax that will do that. Did I miss it? Thanks, Jon
