[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]07/01/2018[/TD]
[TD]08/01/2018[/TD]
[TD]09/01/2018[/TD]
[TD]10/01/2018[/TD]
[TD]11/01/2018[/TD]
[TD]12/01/2018
[/TD]
[TD]13/01/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Sunday[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Friday[/TD]
[TD]Saturday[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4.5[/TD]
[TD][/TD]
[TD]7[/TD]
[TD]7
[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have the above in 53 worksheets called Week1 etc. This is using Excel 2003.
How do I use LOOKUP (not VLOOKUP or HLOOKUP) to view the data in a Monthly sheet where the columns and rows are swapped?
I need a Month1 sheet which has the dates in A1 to A31 (changes for each month) and I need Column B in the Month sheet to find the date from column A and match it to the Row 1 in the Week1..Week53 sheets and then to display the corresponding row 3.
Column C is to display the Row 4, Column D displays Row 5 etc.. All dependent on matching the dates for each row in the Month sheet with the data in the Week sheets. Dates will change depending on the month and years involved hence needing to check all 53 weeks for a match.
I need to do this using the LOOKUP function as VBA may not be allowed on some computers.
I could do this long hand by directly addressing each cell from each sheet, but when the years change there will be a lot of relinking needed and human error will screw this up.
So the end result will look like this but with a whole months worth of dates and the date pulled from multiple locations.
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]06/01/2018 (From another worksheet)
[/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]07/01/2018[/TD]
[TD]4.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]08/01/2018[/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]09/01/2018
[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]10/01/2018
[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]11/01/2018[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]12/01/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
. Honestly!!
