Hi All,

I am using Excel 2013 and new to it. I need your expert advise. If answer of this question or similar is already replied, please provide the link to me. I could not find the answer in this forum.

I have numbers 1 to 9 and these numbers are assigned to letters A to Z. For example number 1 is assigned to, say, A, J, X or Number 7 is assigned to, say, B, E, M and so on.

Now, whenever I enter any alphabet or letter in any cell, number should show adjacent to that cell. For example, if I enter A in B1 then 1 should show in C1 or J in D2 then 1 should show in E2.

Thanks in anticipation.

Suunil