I have an excel document that has a column list of events with the employees who will be working each event in each row in the first sheet while the second sheet is a list of each employee with the events they will be working listed beneath them. Would it be possible to set up a vlookup function or something similar that auto-populates the data in the second sheet using what's typed into the first to cut down on time spent arranging the sheet? Is there a pre-existing software or online program that would solve this issue? A sample is attached.
Bookmarks