View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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