Identify a cell location in a formula based on value in another cell 1

[mkallover]

What I would like to do is create some kind of formula that will find a cell location based on the value in another cell. For example:

A1 = 35

What I want to do is locate a cell based on a static column identifier plus whatever the value is in cell A1. Let's say the column was always going to be column 'M', then since A1 = 35, the cell reference I want would be M35.

Does that make sense?

 

[SkipVought]

Hi,

How do you want this to function. Please explain step by step.

You start out with 35 in A1. So FIRST you do WHAT and then WHAT happens?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mkallover]

OK, to try again:

Cell A1 = 35 (could be any number)

Another cell has a formula like:

="M" & A1 where the reference will be to Column M and Row (whatever is in Cell A1)

 

[SkipVought]

So this?
[tt]
=INDIRECT("M"&A1)
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mkallover]

That would appear to be it.

Thanks!

 

[SkipVought]

So you want to return a value from the ROW designated in A1 in COLUMN M.

Another more straight-forward method would be...
[tt]
=INDEX(M:M,A1,1)
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]