Hi,

I need to able to copy a formula from a cell in another worksheet,
which I find by using a V lookup, and have it use that formula in a
cell......


Sheet A: (Value's View)

A B
1 ESP 0.25
2 ERT =OFFSET(THISCELL, 1, 0)
3 ERR 0.45

Sheet B: (Formula View)

A B
1 ESP =VLOOKUP(A1,Sheet A!$A$6:$I$311,3,FALSE)
2 ERT =VLOOKUP(A2,Sheet A!$A$6:$I$311,3,FALSE)
3 ESP =VLOOKUP(A3,Sheet A!$A$6:$I$311,3,FALSE)
4 ESR =VLOOKUP(A3,Sheet A!$A$6:$I$311,3,FALSE)
5 ERT =VLOOKUP(A3,Sheet A!$A$6:$I$311,3,FALSE)

Sheet B: (Value's View)

A B
1 ESP 0.25
2 ERT 0.25
3 ESP 0.25
4 ERR 0.45
5 ERT 0.45



So when column A (on sheet B) has ESP in it it gets the value from the
ESP row in sheet A, but if it has ERT in it it will take the formula
from sheet a and use it to get the value from the row above.

Any ideas? Hope I have explained myself properly.

Thanks in advance for your help.

Phil