Numbers and letters...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

silas - 09 Nov 2007 02:14 GMT

Hi. I have in column A the numbers 1- 26, in column B the letters A- Z. I'm
trying to create a formula wherein, when I type a number 1- 26 in C, the
corresponding letter will appear in D (if I type '1', 'A' will appear, if I
type '2', 'B' will appear, and so on). I was nesting a VLOOKUP in an IF
function but I'm having problems. I suspect I'm making this more complicated
than need be.

I'd appreciate some assistance.

silas

Reply to this Message

carlo - 09 Nov 2007 02:18 GMT

> Hi. I have in column A the numbers 1- 26, in column B the letters A- Z. I'm
> trying to create a formula wherein, when I type a number 1- 26 in C, the
[quoted text clipped - 6 lines]
>
> silas

try this

in c1 you put in the number and in D1:

if you want to have uppercase Letters
=char(C1+ 64)

if you want to have lowercase Letters
=lower(char(C1+64))
or
=char(C1 + 96)

hth

Carlo

Reply to this Message

silas - 09 Nov 2007 03:17 GMT

That's exactly what I need.

Thanks, Carlo.

silas

>> Hi. I have in column A the numbers 1- 26, in column B the letters A- Z.
>> I'm
[quoted text clipped - 25 lines]
>
> Carlo

Reply to this Message

T. Valko - 09 Nov 2007 03:05 GMT

Assume the letters are in the range B1:B26.

=INDEX(B$1:B$26,C1)

If C1 is empty the formula will return "A". You can prevent that by using
this:

=IF(ISNUMBER(C1),INDEX(B$1:B$26,C1),"")

Signature

Biff
Microsoft Excel MVP

> Hi. I have in column A the numbers 1- 26, in column B the letters A- Z.
> I'm trying to create a formula wherein, when I type a number 1- 26 in C,
[quoted text clipped - 6 lines]
>
> silas

Reply to this Message