LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How a cell can be addressed with variable file-column?

for example :
I have A1 value as "hello"

I define A2 = "A"
I define B2 = "1"
I wish that if I type in A3 the value =A2&B2
the value I see in the A3 cell were "hello", instead what I see is "A1"

Does anyone know if it is possible to address a cell (A1) by defining the
column and the file as variables contained in other cells (in my example A2
and A3)?

Thanks

Victor
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Variable in VLOOKUP and referencing a cell another file in excel Dave T at home Excel Worksheet Functions 1 August 9th 06 03:14 AM
questions being addressed Luke Excel Worksheet Functions 9 November 11th 05 07:21 PM
how do I use variable column and rows using other cell reference . Bomber Excel Worksheet Functions 2 July 15th 05 06:39 PM
reference cell value from fixed column with variable row bob z Excel Discussion (Misc queries) 0 May 23rd 05 11:30 PM
how to create a variable column in cell reference Sampson Excel Worksheet Functions 3 February 21st 05 10:13 PM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"