Selecting entire rows based on contents of cell?

Hi there,

I have a large set of data regarding the activities going on in particular rooms. The data contains activity name, start time, day, duration, room and size.

I would like to select all rows that contain a cell in the activity name column which contain the words 'VideoConference'.

I have tried to Search, Select All then index the remaining data using =iferror(index(etc. However some activities occur in more than one room and all variables apart from 'Room' are the same. Thus when I have tried to index the room column I get the same room for both rows.

Please see attached spread sheet for the raw data and my desired result.

Thanks in advance.

ps the raw data set consists of +28000 rows so I can not simply look through and copy.