A Formula will return a value to the cell that holds the formula.

You'd need some VBA to do what you want.

dim myStrCell as range
dim myAddrCell as range

with activesheet
set mystrcell = .range("a1")
set myaddrcell = .range("b9")
.range(myaddrcell.value).value = mystrcell.value
end with

---
This has no validation at all!

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Tattyfur wrote:

In one cell I have a String And in another cell I have a reference to a cell.
How do I put the String into the referenced cell?

--

Dave Peterson