PDA

View Full Version : Solved: Indirect using row numbers.



mdmackillop
02-25-2009, 03:29 AM
Indirect always gets my brain spinning. Can I use an Indirect function in D7 to I7 (170 columns in the real case) which will allow me to change the row number in C7 to get the required formulae?
No VBA solutions please.

xld
02-25-2009, 03:44 AM
Is this what you want?

=INDIRECT(ADDRESS($C$7,COLUMN()))*INDIRECT("Sheet2!"&ADDRESS($C$7,COLUMN()))

mdmackillop
02-25-2009, 05:18 AM
Spot on as usual Bob. Thanks a lot.