=IF('55LHX'!$K$6=0,'55LHX'!$J$6,'55LHX'!$K$6)*'IRP lan And ST'!$B$6

It really depends how the above start cell formula in Sheet2 should be
propagated. The $ signs for the cell refs make it absolute, ie fixed (doesn't
change). Remove the $ sign(s), and it becomes relative, meaning it will
increment correspondingly as you copy it across or down.

As an example, for your expression, if: 'IRPlan And ST'!$B$6 is to remain
fixed while the rest are to increment correspondingly as you copy down, make
it:
=IF('55LHX'!K6=0,'55LHX'!J6,'55LHX'!K6)*'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