Variable Cell Reference

Posted to microsoft.public.excel.misc

Sean Timmons Sean Timmons is offline

external usenet poster

Posts: 1,696

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vba variable value via cell reference	Bill (Unique as my name)	Excel Discussion (Misc queries)	3	November 29th 06 12:40 AM
Using an offset formula for the reference in a relative reference	Cuda	Excel Worksheet Functions	6	November 15th 06 05:12 PM
Urgent date/scheduling calc needed	jct	Excel Worksheet Functions	3	February 24th 06 01:36 AM
Cell Reference Math	Ralph Howarth	Excel Worksheet Functions	0	January 26th 05 06:27 PM
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable	[email protected]	Excel Worksheet Functions	2	December 11th 04 12:00 AM

All times are GMT +1. The time now is 02:26 AM.

Menu

About Us