Concatenation Setback
 

In Cells A1:A12; Jan €“ Dec.
In cell B1 is the number 1 with a scrollbar linked to it whose range is 1-12.
In cell C3 is the wrong formula; ="A" & B1.
The scrollbar is fine incrementing / decrementing as it should.
Any advice on how to write the concatenation thatll return the result of
that formula; Jan, Feb as opposed to A and the # n cell B1?
Appreciatively,
Arturo

Concatenation Setback
 

Try this in C1:

=INDIRECT("A"&B1)

Hope this helps.

Pete

On Dec 5, 3:11*pm, Arturo wrote:
In Cells A1:A12; Jan – Dec.
In cell B1 is the number 1 with a scrollbar linked to it whose range is 1-12.
In cell C3 is the wrong formula; ="A" & B1.
The scrollbar is fine incrementing / decrementing as it should.
Any advice on how to write the concatenation that’ll return the result of
that formula; Jan, Feb as opposed to A and the # n cell B1?
Appreciatively,
Arturo

Concatenation Setback
 

A non-volatile solution would be...

=INDEX(A1:A12,B1)

--
Rick (MVP - Excel)


"Pete_UK" wrote in message
...
Try this in C1:

=INDIRECT("A"&B1)

Hope this helps.

Pete

On Dec 5, 3:11 pm, Arturo wrote:
In Cells A1:A12; Jan – Dec.
In cell B1 is the number 1 with a scrollbar linked to it whose range is
1-12.
In cell C3 is the wrong formula; ="A" & B1.
The scrollbar is fine incrementing / decrementing as it should.
Any advice on how to write the concatenation that’ll return the result of
that formula; Jan, Feb as opposed to A and the # n cell B1?
Appreciatively,
Arturo

Concatenation Setback
 

Hi,

1. You can use indirect or

=TEXT(B1,"mmm")
=INDIRECT("A"&B1)

2. Why not just give the user a drop down list in B1 with the 12 months.
Choose Data, Validation, from Allows pick List and in Source enter =A1:A12.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Arturo" wrote:

In Cells A1:A12; Jan €“ Dec.
In cell B1 is the number 1 with a scrollbar linked to it whose range is 1-12.
In cell C3 is the wrong formula; ="A" & B1.
The scrollbar is fine incrementing / decrementing as it should.
Any advice on how to write the concatenation thatll return the result of
that formula; Jan, Feb as opposed to A and the # n cell B1?
Appreciatively,
Arturo

Concatenation Setback
 

Hi,
Not useing Dropdown because the list is 7800 rows.
Vlookup in the mix too and we're trying to trace a certain problem in the
data sets.
Incrementing with Scroll or spinner seemed better & this glitch was
bothering me.
Thank you guys for your help!
A

"Shane Devenshire" wrote:

Hi,

1. You can use indirect or

=TEXT(B1,"mmm")
=INDIRECT("A"&B1)

2. Why not just give the user a drop down list in B1 with the 12 months.
Choose Data, Validation, from Allows pick List and in Source enter =A1:A12.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Arturo" wrote:

In Cells A1:A12; Jan €“ Dec.
In cell B1 is the number 1 with a scrollbar linked to it whose range is 1-12.
In cell C3 is the wrong formula; ="A" & B1.
The scrollbar is fine incrementing / decrementing as it should.
Any advice on how to write the concatenation thatll return the result of
that formula; Jan, Feb as opposed to A and the # n cell B1?
Appreciatively,
Arturo