functions derived from cell contents
 

Lets's day A1 has the letter B in it and A2 has the number 3 in it.

Is it possible to have a formula display the contents of B3 using
references to cells A1 and A2?

Thanx

X-posted to microsoft.public.excel.programming

functions derived from cell contents
 

Try this:

=INDIRECT(A1&A2)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

Lets's day A1 has the letter B in it and A2 has the number 3 in it.

Is it possible to have a formula display the contents of B3 using
references to cells A1 and A2?

Thanx

X-posted to microsoft.public.excel.programming

functions derived from cell contents
 

works great, just wanted i wanted

thanx

Ron Coderre wrote:
Try this:

=INDIRECT(A1&A2)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

Lets's day A1 has the letter B in it and A2 has the number 3 in it.

Is it possible to have a formula display the contents of B3 using
references to cells A1 and A2?

Thanx

X-posted to microsoft.public.excel.programming

functions derived from cell contents
 

What a waste of my time and effort answering the same question in the
programming news group.

Please refrain from multi-posting.

Cross-post if you must, but not multi-post.


Gord Dibben MS Excel MVP

On 13 Sep 2006 13:50:25 -0700, wrote:

works great, just wanted i wanted

thanx

Ron Coderre wrote:
Try this:

=INDIRECT(A1&A2)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

Lets's day A1 has the letter B in it and A2 has the number 3 in it.

Is it possible to have a formula display the contents of B3 using
references to cells A1 and A2?

Thanx

X-posted to microsoft.public.excel.programming