| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell contents to refrenence cells | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
