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

[Guest]

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?

 

[Bernard Liengme]

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

 

[Guest]

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.