| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas derived from cells
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas derived from cells
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas derived from cells
=INDIRECT(A1&A2)
Gord Dibben MS Excel MVP On 13 Sep 2006 13:22:22 -0700, 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers derived from @ right function don't add | Excel Discussion (Misc queries) | |||
| Replace a derived value with a label | Excel Discussion (Misc queries) | |||
| Vlookup derived wrong value | Excel Worksheet Functions | |||
| how can I paste values derived from formulas into a different book | Excel Worksheet Functions | |||
| Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
Linear Mode
