Limit of choose function up to index no. (2)

C

Cheryl

Sheet 1 contains the summary which will draw the data from sheet 2. Sheet 2 contains column of data for Day 1 to Day 31. I wish to do this on sheet 1 - if I key in 2, it will pick up data from sheet 2 under the column Day 2. If I key in 3, it will pick up data from sheet 2 under the column day 3 etc
 
F

Frank Kabel

Hi
and what exact values are the column headers of sheet2 (e.g. real date
values, just a number 1-31, etc.)
Please post some example rows of data (plain text - no attachment
please)

You may also stay in the original thread :)

--
Regards
Frank Kabel
Frankfurt, Germany

Cheryl said:
Sheet 1 contains the summary which will draw the data from sheet 2.
Click to expand...
Sheet 2 contains column of data for Day 1 to Day 31. I wish to do this
on sheet 1 - if I key in 2, it will pick up data from sheet 2 under the
column Day 2. If I key in 3, it will pick up data from sheet 2 under
the column day 3 etc
 
C

cheryl

Eg.
Sheet 1 at column A1, I will key the date no. eg "1" to represent day 1 and "2" to represent day
Row in worksheet 1 and 2 is the same eg. Row 2:Sale of product ABC, Row 3: Sale of product DE
Column 2 to 32, row 1 are no. from 1 to 31 in worksheet
If I input worksheet 1 at A1, "1"
B2 in worksheet 1 will extract figure from worksheet 2, B
B3 in worksheet 1 will extract figure from worksheet 2, B
If I input worksheet 1 at A1, " 3
B2 in worksheet 1 will extract figure from worksheet 2, D
B3 in worksheet 1 will extract figure from worksheet 2, D3 and so o
I tried using choose function in worksheet 1 B2 & B3 but I am limited to 29 index no
Thank you. Hope above is clear.


----- Frank Kabel wrote: ----

H
and what exact values are the column headers of sheet2 (e.g. real dat
values, just a number 1-31, etc.
Please post some example rows of data (plain text - no attachmen
please

You may also stay in the original thread :-

-
Regard
Frank Kabe
Frankfurt, German

Cheryl said:
Sheet 1 contains the summary which will draw the data from sheet 2
Click to expand...
Sheet 2 contains column of data for Day 1 to Day 31. I wish to do thi
on sheet 1 - if I key in 2, it will pick up data from sheet 2 under th
column Day 2. If I key in 3, it will pick up data from sheet 2 unde
the column day 3 et
 
F

Frank Kabel

Hi
enter the following formula in cell B2 of your worksheet1:
=OFFSET('worksheet2'!$B2,0,$A$1-1)
and copy this down
 
Top