Discussion Locked

Excel function help

0 helpful

3 replies

by gdemoura Jul 22, 2002 last reply Jul 23, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a cell F2 that contains the value B3.
I would like to have the value of B3 in the cell F2.

Thanks

3 replies

The question is a little vague, but here are a couple of answers.
To put the value of B3 in cell F2, you need a formula. Type:

=B3

in Cell F2 and hit Enter.

If you are entering the address "B3" in cell F2,
You can refer to the value of that address.

In cell F3 enter the formula:

=INDIRECT(F2)

If I'm off the mark, please reword your question.

Thank you very much

This question was closed by the author

This discussion is closed to new replies.