ExcelBanter - Variable Cell Reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Variable Cell Reference (https://www.excelbanter.com/excel-discussion-misc-queries/124040-variable-cell-reference.html)

Andrew

Variable Cell Reference

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

RichardSchollar

Variable Cell Reference

Hi Andrew

How about:

=INDEX($C:$C,B1)

Hope this helps!

Richard

Andrew wrote:

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

Sean Timmons

Variable Cell Reference

=concatenate("C",B1)

"Andrew" wrote:

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

Sean Timmons

Variable Cell Reference

or:
="C"&B1

"Sean Timmons" wrote:

=concatenate("C",B1)

"Andrew" wrote:

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

All times are GMT +1. The time now is 06:37 AM.