Answer for:

How create a formula to copy but have the row change by fixed number?

Message 4 of 3

View entire thread
0 Votes

Thank you. My knowledge of Excel does not include INDEX function. I did some research but am still confused. The destination cells are in a contiguous vertical range. Can you be a bit more detailed. If my 1st destination cell is in sheet Summary B1 and the info needed comes from 'KI 2011'!L16, and my 2nd destination cell is Summary B2 and the info comes from 'KI 2011'!L23 what exact formula would be entered in cells B1 and B2? The range of cells that contains the needed info are in sheet KI 2011 from L1 thru L400. Thanks.