cell

  • Thread starter Thread starter Nigel123
  • Start date Start date
N

Nigel123

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
 
Try using INDIRECT() function with a fixed column....

If this post helps click Yes
 
One more:
=index(e:e,a1)


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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access My Expression Contains Wrong number of arguments 0
Council unfairly closes one of Europe's biggest nightclubs! And I never got a chance to go. 11
Word Using the 'IF' Formula in MS Word 2010 0
Area under the curve calculation 2
Sum on 2 criteria, incl #REF! 2
Formula to sum columns based on # in Cell A1 8
Formula Fill Problems 6
Form Design/Multi-Level 2

Back
Top