I have a large amount of data regarding room activities on a university campus. The variables are: Day (Mon-Fri), Time (09:00-16:00), Room and Duration (1-9 hours). In worksheet 1, these variables are positioned in columns with each row representing the different activities taking place.
I have tried using logic functions but I cant get it to work. All I want to do is import the duration of events from the first worksheet into that of the second given the selected room, date and time. So, if the room is Room001, the date dd/mm/yyyy, and the time 09:00 then the duration of the event equals x=1 to 9. The answer must be a formula as I have a great deal of info to sort through.
I hope this makes sense. Thank you in advance for any suggestions.