cel content is reference for cel in formula

[maujor]

Say I have:
A1 = 27
A2 = 36
A3 = 117
...
and
...
M27 = aaa
...
M36 = bbb
...
M117 = ccc


How to insert in B column formulas that retrives values picked from M column and lines picked from A column values.
Something like:

B1 fx = M(A1value) results in => A27
B2 fx = M(A2value) results in => A36
B3 fx = M(A3value) results in => A117

ending with

B1 = aaa
B2 = bbb
B3 = ccc
...

Thanks in advanced.

[JBeaucaire]

In B1:
=INDEX(M:M, A1)

...then copy that down.

[maujor]

Hi JBeaucaire,
Many thanks.
Works like a charm.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.