- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- RE: Using the Cell descriptor in the formula

Subject: | RE: Using the Cell descriptor in the formula |

Posted by: | Ron Coderre |

Date: | Tue, 2 May 2006 |

Try something like this:

=INDIRECT("A"&B2)

Does that help?

***********

Regards,

Ron

XL2002, WinXP-Pro

"Davezico" wrote:

> I am trying to write a formula where the cell descriptor is part of the

> formula. Eg A1: =A2

> this puts the value of cell A2 into A1

> A1: =A{B2}

> If I enter 2 into B2 then A1 shows the value of A2. If I put 7 into B2 then

> A1 becomes the value of A7.

>

> Is there a way of doing the above?

None

Using the Cell descriptor in the formula posted by Davezico on Tue, 2 May 2006