# Conversion Snag

G

#### Guest

A1:A12 = 1 through 12
B1:B12 = Letters A through L
C1 = 8
C2 = VLOOKUP(C1,A1B12,2)
C3 = CONCATENATE(C2,"26")
What C3 displays as text is H26.
I want to see the result of cell H26 in cell C3.
Donâ€™t know how to convert what Iâ€™ve got to what I needâ€¦

M

#### Myrna Larson

The critical formula you need is INDIRECT. That takes text that looks like a
cell reference and treats it as such. But you don't need to use VLOOKUP to
translate the numbers 1-26 to the letters A-Z. The ASCII code for A is 65, for
B is 66, etc. so you can get everything into one formula like this:

=INDIRECT(CHAR(C1+64)&"26")

D

#### Domenic

Hi Arturo,

Try...

=INDIRECT(CONCATENATE(C2,"26"))

OR

=INDIRECT(C2&"26")

Hope this helps!

H

#### hgrove

Arturo wrote...
A1:A12 = 1 through 12
B1:B12 = Letters A through L
C1 = 8
C2 = VLOOKUP(C1,A1B12,2)
C3 = CONCATENATE(C2,"26")
What C3 displays as text is H26.
I want to see the result of cell H26 in cell C3.
...

Alternativesthat doesn't require the lookup,

=INDIRECT("R26C"&C1,0)

=INDEX(\$1:\$65536,26,C1