I have a schedule of different events which occur throughout the year, over a number of years. Columns D through BD are the week numbers (1-52). The events are listed in Column C, and the year in Column A. A mock-up of this schedule is on Source sheet of the attached file.
How can the schedule on the Target sheet of the attached file be populated from the Source sheet?
What challenges me is that the year and event are on the same row with week numbers spread across the columns on the source schedule, but only one event is on a given row with year and week numbers spread across the columns on the target schedule.
I've looked at 2-way lookup solutions (INDEX MATCH and VLOOKUP MATCH) and multi-condition vlookup, but these seem to depend on the criteria being on the same row.
Note: I'm not sure I'm attaching the spreadsheet properly. The paperclip icon only opens/closes a narrow rectangle, and I'm not sure that Manage Attachments is attaching the file to this thread.
Bookmarks