Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation | Excel Discussion (Misc queries) | |||
Concatenation | Excel Worksheet Functions | |||
Concatenation | Excel Discussion (Misc queries) | |||
concatenation | Excel Discussion (Misc queries) | |||
PLEASE HELP!? Creating a simple database with excel, minor setback | Excel Worksheet Functions |