ILLUSTRATIVE EXAMPLE OF WHAT I’M ASKING:
I have two spreadsheets, Sheet1 (source sheet) and Sheet2 (target sheet). Sheet1 has data with corresponds to each of the 365 days of the year. Sheet2 desires to reproduce portions of Sheet1 data based on a common “peg” or reference value. In short, I want to type a day of the year into Sheet2, and the corresponding data from Sheet1 is reproduced into Sheet2.
STRUCTURE OF SHEET1 (source sheet):
Sheet1-Column A (Number of Days into Year) ... Sheet1 has 365 rows, one for each day of the year. In cell A1 is the number “1”, with each row being increased by one unit such that cell A365 containes the number “365.” (Sheet 1, Column A values are I want to serves as “pegs.”)
Sheet1-ColumnB (Name of Month) ... contains the name of the month corresponding to the Column A value. So, cell B1 = “January” (1st day of year is January 1st); cell B50 = “February” (the 50th day of the year is February 19th), and so on.
Sheet1-ColumnC (Day of Month) ... contains the day of the month. So, cell C1 = “1” (1st day of year is January 1st), and cell B50=“19” (the 50th day of the year is February 19th).
SHEET2 (target sheet):
The desire is to have a formula to pull Sheet1-ColumnB and Sheet1-ColumnC data into Sheet2 by merely typing, into Sheet2, the corresponding Sheet1-Column A “peg” value. That is to say, if I type into a Sheet2-ColumnA row any number between 1 and 365, the Sheet1 data corresponding to that “peg” (days-into-the-year) number will be displayed in Sheet2.
Continuing by way of example, if I type the number “1” into Cell A429 of Sheet2, the text “January” appears in Cell B429, and the number “1” appears in Cell C429. Or, say, if I type the number “50” into Cell A429 of Sheet2, the text “February” appears in Cell B429, and the number “19” appears in Cell C429.
QUERY:
¿Do you have ideas as to a formula which might accomplished the stated task?
[FWIW: although the above example is simplified, I am indeed working to translate information from one type of calendar to another based on “peg” days common to each. The search-and-find-and-cut-and-pasting between the two sheets is laborious and subject to error. My hope is to merely type the ‘day-into-the-year’ value into my Target Sheet, and have all the corresponding ‘day-into-the-year’ data in the Source Sheet copied over.]
Thank you in advance.
I have two spreadsheets, Sheet1 (source sheet) and Sheet2 (target sheet). Sheet1 has data with corresponds to each of the 365 days of the year. Sheet2 desires to reproduce portions of Sheet1 data based on a common “peg” or reference value. In short, I want to type a day of the year into Sheet2, and the corresponding data from Sheet1 is reproduced into Sheet2.
STRUCTURE OF SHEET1 (source sheet):
Sheet1-Column A (Number of Days into Year) ... Sheet1 has 365 rows, one for each day of the year. In cell A1 is the number “1”, with each row being increased by one unit such that cell A365 containes the number “365.” (Sheet 1, Column A values are I want to serves as “pegs.”)
Sheet1-ColumnB (Name of Month) ... contains the name of the month corresponding to the Column A value. So, cell B1 = “January” (1st day of year is January 1st); cell B50 = “February” (the 50th day of the year is February 19th), and so on.
Sheet1-ColumnC (Day of Month) ... contains the day of the month. So, cell C1 = “1” (1st day of year is January 1st), and cell B50=“19” (the 50th day of the year is February 19th).
SHEET2 (target sheet):
The desire is to have a formula to pull Sheet1-ColumnB and Sheet1-ColumnC data into Sheet2 by merely typing, into Sheet2, the corresponding Sheet1-Column A “peg” value. That is to say, if I type into a Sheet2-ColumnA row any number between 1 and 365, the Sheet1 data corresponding to that “peg” (days-into-the-year) number will be displayed in Sheet2.
Continuing by way of example, if I type the number “1” into Cell A429 of Sheet2, the text “January” appears in Cell B429, and the number “1” appears in Cell C429. Or, say, if I type the number “50” into Cell A429 of Sheet2, the text “February” appears in Cell B429, and the number “19” appears in Cell C429.
QUERY:
¿Do you have ideas as to a formula which might accomplished the stated task?
[FWIW: although the above example is simplified, I am indeed working to translate information from one type of calendar to another based on “peg” days common to each. The search-and-find-and-cut-and-pasting between the two sheets is laborious and subject to error. My hope is to merely type the ‘day-into-the-year’ value into my Target Sheet, and have all the corresponding ‘day-into-the-year’ data in the Source Sheet copied over.]
Thank you in advance.
