Adding formulas based on range names

  • Thread starter Thread starter soteman2005
  • Start date Start date
S

soteman2005

Hi,

I have a workbook with three sheets(inputs, overrides, actuals) calle
Demand I, Demand O and Demand A. Each row is range named betwee
columns J and T, with the same name on each sheet, with the exceptio
of the prefixes DCI, DCOV and DCA dependant upon sheet. I would lik
to add a formula to every cell in Demand A column J that is a part of
range name such that the formula is;

=if(and(DCO_overrides_enabled=TRUE,DCOV_blahblah<>""),DCOV_blahblah,DCI_blahblah)

where DCOV/DCI blahblah is the range name used on the current row.
Does anyone have any ideas as I am quite stumped at the moment.

Thanks

Ada
 
Hi Adam, ..........
I don't think anyone knows what you are trying to do? Could you be more
specific
 
Back
Top