W
WembleyBear
Hi
I have a worksheet where the user enters the month they are interested in
the data for from a drop-down box A2. I then had a HLOOKUP to find the value
from the column for that month. This worked fine. The problem is, each month
is now going to have 2 columns under it (one for this year & one for last
year) and from what I've read HLOOKUP may no longer be the right solution and
perhaps INDEX &/or MATCH would be better but I'm struggling with the how the
formula would read.
The spreadsheet now looks like this below, with month names in row 1 being
centred across each pair of year columns in row 2. My formula goes in row 3
under the Export column. When the user selects, say January in cell A2, then
in row 3 under Export 2008 it should read 55. If they changed the month to
February, the formula should return 72.
Month January February Export
January 2008 2007 2008 2007 2008 2007
55 111 72 19
Any help with this would be very much appreciated!
Thanks
Martyn
Excel 2000, Windows Server 2003 over Citrix PS4
I have a worksheet where the user enters the month they are interested in
the data for from a drop-down box A2. I then had a HLOOKUP to find the value
from the column for that month. This worked fine. The problem is, each month
is now going to have 2 columns under it (one for this year & one for last
year) and from what I've read HLOOKUP may no longer be the right solution and
perhaps INDEX &/or MATCH would be better but I'm struggling with the how the
formula would read.
The spreadsheet now looks like this below, with month names in row 1 being
centred across each pair of year columns in row 2. My formula goes in row 3
under the Export column. When the user selects, say January in cell A2, then
in row 3 under Export 2008 it should read 55. If they changed the month to
February, the formula should return 72.
Month January February Export
January 2008 2007 2008 2007 2008 2007
55 111 72 19
Any help with this would be very much appreciated!
Thanks
Martyn
Excel 2000, Windows Server 2003 over Citrix PS4