Worksheet function to retrieve cell value based on row an col numb
 

I want to be able to reference cells by the row number an column number
rather than using the column letter. I am contatenating strings to make a
formula where I increment the column. I have tried r1c1 notation and this
doesn't seem to work for me. Is there a function like +cellvalue(1,1) that
will return the value in a1?

Worksheet function to retrieve cell value based on row an col numb
 

If cells E1 and E2 hold numbers such as 1,2,3 or then
=INDIRECT(CHOOSE(E1,"A","B","C","D")&E2)
will point to cells such as A1, C4, etc
You will need to expand the CHOOSE part to get to less past column D
This will work up to column Z
=INDIRECT(CHAR(E1+96)&E2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mcambrose" wrote in message
...
I want to be able to reference cells by the row number an column number
rather than using the column letter. I am contatenating strings to make a
formula where I increment the column. I have tried r1c1 notation and this
doesn't seem to work for me. Is there a function like +cellvalue(1,1) that
will return the value in a1?

Worksheet function to retrieve cell value based on row an col numb
 

The offset function can do that for you. John Walk also uses the Match
function to determine column number -
http://j-walk.com/ss/excel/usertips/tip020.htm. You might be able to modify
that to handle your requirements.

"mcambrose" wrote:

I want to be able to reference cells by the row number an column number
rather than using the column letter. I am contatenating strings to make a
formula where I increment the column. I have tried r1c1 notation and this
doesn't seem to work for me. Is there a function like +cellvalue(1,1) that
will return the value in a1?