| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic reference to cell??
If I have values in cells A1:B2 for example
1,2 3,4 In A4, I'd like to be able to type the cell, and have B4 populate with the value in the cell. So if in A4 I type 'A2', the number 3 would populate in B4. Likewise, if in A4 I change the entry and type 'B2', I want the number 4 to populate in B4. Does that make sense??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dynamic reference to cell??
It makes sense. There is a function just for you:
=INDIRECT(A4) -- Gary's Student gsnu200705 "mfrey" wrote: If I have values in cells A1:B2 for example 1,2 3,4 In A4, I'd like to be able to type the cell, and have B4 populate with the value in the cell. So if in A4 I type 'A2', the number 3 would populate in B4. Likewise, if in A4 I change the entry and type 'B2', I want the number 4 to populate in B4. Does that make sense??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dynamic reference to cell??
WOW, that was too easy!
you rock, thanks! "Gary''s Student" wrote: It makes sense. There is a function just for you: =INDIRECT(A4) -- Gary's Student gsnu200705 "mfrey" wrote: If I have values in cells A1:B2 for example 1,2 3,4 In A4, I'd like to be able to type the cell, and have B4 populate with the value in the cell. So if in A4 I type 'A2', the number 3 would populate in B4. Likewise, if in A4 I change the entry and type 'B2', I want the number 4 to populate in B4. Does that make sense??? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dynamic reference to cell??
Excel rocks, I just roll.
-- Gary's Student gsnu200705 "mfrey" wrote: WOW, that was too easy! you rock, thanks! "Gary''s Student" wrote: It makes sense. There is a function just for you: =INDIRECT(A4) -- Gary's Student gsnu200705 "mfrey" wrote: If I have values in cells A1:B2 for example 1,2 3,4 In A4, I'd like to be able to type the cell, and have B4 populate with the value in the cell. So if in A4 I type 'A2', the number 3 would populate in B4. Likewise, if in A4 I change the entry and type 'B2', I want the number 4 to populate in B4. Does that make sense??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| dynamic cell reference within a text string | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
