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!!!


--
nevi
------------------------------------------------------------------------
nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238
View this thread: http://www.excelforum.com/showthread...hreadid=552854