| 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??? |
| 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 | |||
Threaded Mode
