Good day
Please can anyone help me with this query:
On Sheet 1 of my spreadsheet I have a list of products in rows down and Months in columns across. The months are not fixed and may change as periods roll ( e.g. first quarter to second quarter) - So column B can be "July_2007" now but can change to "October_2007" in a few months time. To help with my Vlookup reference, I have numbered the columns in row 1 ( column A =1, column B = 2 etc ).
On sheet 2 ( Cell E4) , I have a cell that I enter the Month name.
Also on Sheet 2, in ( cell E7 ), I have a vlookup that is looking for the "product" in (D7) in the list on sheet 1, then checking the Month in (E4) on sheet 2, find the column number that the month is in and return the data from that column.
The formula I am using in cell E7 is:
=VLOOKUP(D7,Report1!$A:$AY,LOOKUP($E$4,Report1!$A$5:$S$5,Report1!$A$1:$S$1),0)
The problem i am having is that the lookup function in the formula is only working if (cell E4) is the first month in the list ( cell B5 on sheet 1).
I hope this is making sense.
I would like to know what I am doing wrong or perhaps there is an easier way.
I would appreciate any help
Thank
JVN
Please can anyone help me with this query:
On Sheet 1 of my spreadsheet I have a list of products in rows down and Months in columns across. The months are not fixed and may change as periods roll ( e.g. first quarter to second quarter) - So column B can be "July_2007" now but can change to "October_2007" in a few months time. To help with my Vlookup reference, I have numbered the columns in row 1 ( column A =1, column B = 2 etc ).
On sheet 2 ( Cell E4) , I have a cell that I enter the Month name.
Also on Sheet 2, in ( cell E7 ), I have a vlookup that is looking for the "product" in (D7) in the list on sheet 1, then checking the Month in (E4) on sheet 2, find the column number that the month is in and return the data from that column.
The formula I am using in cell E7 is:
=VLOOKUP(D7,Report1!$A:$AY,LOOKUP($E$4,Report1!$A$5:$S$5,Report1!$A$1:$S$1),0)
The problem i am having is that the lookup function in the formula is only working if (cell E4) is the first month in the list ( cell B5 on sheet 1).
I hope this is making sense.
I would like to know what I am doing wrong or perhaps there is an easier way.
I would appreciate any help
Thank
JVN