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?

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?

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?