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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top