Conversion Snag

[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…

 

[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")

 

[Domenic]

Hi Arturo,

Try...

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

OR

=INDIRECT(C2&"26")

Hope this helps!

 

[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