Trying to use a cell value to reference another cell

kwaring · Mar 16th, 2002, 06:45 PM

For example, if i have the value 5 in B1 and i want to use that value to reference a cell in column C, ie the formula for A1 is something like:

=C(B1)

obviously that doesn't work, but i hope you get the just of it.
Thanks!

Dave Hawley · Mar 16th, 2002, 06:56 PM

Hi

You need the INDIRECT function

=INDIRECT("C"&B1)

Anne Troy · Mar 16th, 2002, 07:00 PM

Go to bed, Dave.

kwaring · Mar 16th, 2002, 07:01 PM

Thank you Dave!

Dave Hawley · Mar 16th, 2002, 07:06 PM

My pleasure kwaring

Tuggy, I can't sleep with both arms in a cast

)

Mar 16th, 2002, 07:00 PM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Go to bed, Dave. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 16th, 2002, 06:45 PM	#1
kwaring New Member Join Date: Mar 2002 Location: Nanaimo, BC Posts: 49	For example, if i have the value 5 in B1 and i want to use that value to reference a cell in column C, ie the formula for A1 is something like: =C(B1) obviously that doesn't work, but i hope you get the just of it. Thanks!

Mar 16th, 2002, 06:56 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi You need the INDIRECT function =INDIRECT("C"&B1)

Mar 16th, 2002, 07:01 PM	#4
kwaring New Member Join Date: Mar 2002 Location: Nanaimo, BC Posts: 49	Thank you Dave!

Mar 16th, 2002, 07:06 PM	#5
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	My pleasure kwaring Tuggy, I can't sleep with both arms in a cast )