Hi All,

I had already posted this question in given below link and it was advised to me that I should post in this forum.

http://www.excelforum.com/excel-form...d-letters.html

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 8 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, if 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.

More example:

If I type, say A or I, anywhere in the worksheet, their corresponding numbers should show next/below to them. Example, B29 = A, it should show 1 to B30 or C29.

B29 = A C29 = 1

or

B30 = 1

One more example, AC30 = R, it should show 2 to AC31 or AD30.

AC30 = R AD30 = 2

or

AC31 = 2

Thanks in anticipation.

Suunil