| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell
Hi I was wondering if someone can help me......
Basically I need a formula that will show me the substance of a cell for example cell A1 says 5 and I want this cell to automatically show me the substance of cell E5 and if i was to chance the 5 to a 8 the cell will show me the substance of cell E8 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell
Hi,
You would need VB code for that so here's a siimpler way. Put the formula below in a cell (say) A2 =INDIRECT("E"&A1) Now put a 3 in A1 and the formula displays the contents of E3 Mike "Nigel123" wrote: Hi I was wondering if someone can help me...... Basically I need a formula that will show me the substance of a cell for example cell A1 says 5 and I want this cell to automatically show me the substance of cell E5 and if i was to chance the 5 to a 8 the cell will show me the substance of cell E8 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell
Try using INDIRECT() function with a fixed column....
If this post helps click Yes --------------- Jacob Skaria "Nigel123" wrote: Hi I was wondering if someone can help me...... Basically I need a formula that will show me the substance of a cell for example cell A1 says 5 and I want this cell to automatically show me the substance of cell E5 and if i was to chance the 5 to a 8 the cell will show me the substance of cell E8 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell
=INDIRECT("E"&A1)
-- David Biddulph "Nigel123" wrote in message ... Hi I was wondering if someone can help me...... Basically I need a formula that will show me the substance of a cell for example cell A1 says 5 and I want this cell to automatically show me the substance of cell E5 and if i was to chance the 5 to a 8 the cell will show me the substance of cell E8 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell
One mo
=index(e:e,a1) Nigel123 wrote: Hi I was wondering if someone can help me...... Basically I need a formula that will show me the substance of a cell for example cell A1 says 5 and I want this cell to automatically show me the substance of cell E5 and if i was to chance the 5 to a 8 the cell will show me the substance of cell E8 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Hybrid Mode
