Variable Cell Reference

A

Andrew

In A1 I want to show the value of cell Cx where x is a variable held in B1
eg.

B1= 5
A1 should show the value of C5

How can I do it please/

TIA
Andy
 

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

how to convert grades into a value 5
Code to format cells on several worksheets 2
Visio: copy text of a master shape to User-define Cells (Variable) 0
Saving a range for later reference 0
Drop down list control value in vba 2
Looking to added up based on a character from cell range 1
Conditional Formatting, Icons 1
Excel not recognizing formula 1

Top