Thanks... Max this is the exact solution i was looking for~~~~

"Max" wrote:

On 2nd thought, focusing on your subject line ..

Maybe you want to increment it down as you copy across:
=IF(OFFSET('55LHX'!$K$6,COLUMNS($A:A)-1,)=0,OFFSET('55LHX'!$J$6,COLUMNS($A:A)-1,),OFFSET('55LHX'!$K$6,COLUMNS($A:A)-1,))*'IRPlan And ST'!$B$6

Or the other way around,
maybe you want to increment it across as you copy down:
=IF(OFFSET('55LHX'!$K$6,,ROWS($1:1)-1)=0,OFFSET('55LHX'!$J$6,,ROWS($1:1)-1),OFFSET('55LHX'!$K$6,,ROWS($1:1)-1))*'IRPlan And ST'!$B$6

Both expressions above presume this term remains fixed:
'IRPlan And ST'!$B$6
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"djc" wrote:
hi i am trying to use column data on sheet 1 to reflect calculation in sheet
2 in column. for exp.
=IF('55LHX'!$K$6=0,'55LHX'!$J$6,'55LHX'!$K$6)*'IRP lan And ST'!$B$6
trying to avoid type in each sell ref., on the sheet2