Hi all,
I'm a bit defeated over this one.
I'm trying to retrieve data in the 'Data' sheet from the relevant station columns C to L and enter them into the columns M to V for the relevant date-time (which are sequential) per station that have the following criterion: the relevant station from columns Z to AI in the 'Criteria' sheet for the respective year/quarter is a "Yes".
I thought index and match functions would work but I'm at a loss.
The attached is a considerably reduced version.
Any suggestions would be greatly appreciated.
Thank you
Bookmarks