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) |