Hoping someone might be able to assist me here. I've inherited a reporting sheet where individual sheets are set up for specific sites. In another sheet there is master data for each site, filtered as follows
Date Date Date Date Date
Site Value Value Value Value Value
Site Value Value Value Value Value
Site Value Value Value Value Value
Site Value Value Value Value Value
Site Value Value Value Value Value
The reporting sheet for each site is set up with the months listed vertically, such as
A B
Jan
Feb
Mar
Apr
Column B needs to have a lookup on the site code, and to match the correct month. I then need to paste the formula down column B in a way that will ensure it's looking up against the correct dates.
Any suggestions of the best way to go about this?
Date Date Date Date Date
Site Value Value Value Value Value
Site Value Value Value Value Value
Site Value Value Value Value Value
Site Value Value Value Value Value
Site Value Value Value Value Value
The reporting sheet for each site is set up with the months listed vertically, such as
A B
Jan
Feb
Mar
Apr
Column B needs to have a lookup on the site code, and to match the correct month. I then need to paste the formula down column B in a way that will ensure it's looking up against the correct dates.
Any suggestions of the best way to go about this?