cell referance

[ceemo]

ok say you had cells A1:A15 like so (A-O)

a
b
c
d
e
f
g..etc

If i wanted to find the cell referance (A:?) of say M can i use a formula do do this?

[swatsp0p]

As long as you know the column is A, you can use MATCH to find the row number:

="A"&MATCH("m",A1:A26)

returns A13

"m" is in row 13 of col. A

HTH

Bruce