Hello All,

Hopefully someone here knows something I dont!

Basically, I need a formula or function that will allow one cell to determine what value is assigned to another cell. What I've been playing with is:

=IF(H1=1,(SUBSTITUTE(Details!D6,"0",D2)))

I've never used SUBSTITUTE before and I think I am applying it wrong...... I'm not sure if it will even do what I am looking for.......

So, what is supposed to happen is that if H1=1 then cell D6 on the Details page will have the same number as cell D2. Eventually it will be an imbedded IF structure that will say that if H1=2 then Details!D7 will be the same number as D2.

The other important part is that I need it to be firm. As in, if I enter the number 1 into H1 then D2 needs to become the same number as Details!D6, but if I then enter the number 2 into H1 then I need the number that was just put into Details!D6 to stay there.

I hope I explained that well; I know it's a little confusing.

Hope someone can help!!!