Partially match text to get a value from another cell

Hi all

attached is a mock sheet of sample Google analytic data.

I would like to do the following:

- have data from sheet 2 auto populate into respective rows in sheet 1.

Through Sumproduct I have been able to have the data from sheet 2 go into sheet 1, but the problem is whenever there is a new document added to the website, there is another link I need to add to the sum product formula.

Ideally I'd like this to be as automated as possible, is there any way to do something like if two cells have partially matching text then pull the value of cells in the unique events (column D).

Sorry If this is stupid, I am new to all this excel stuff and trying to wrap my head around it. Any help would be appreciated, thanks all

Hi than you for your reply, I appreciate it!

So in reality that sheet rather than just having one page under column A, there will be around 15. This number may increase or decrease on weekly basis depending on the pages that are added/taken from this website.

I had just included on random 'xyz' page with random figures inputted for the week, hence the numbers that don't really make sense.

So if I can set it up like you have said above when there is a new page added, lets say 'XYV' can I have the data populate based on the keywords into column E?

The other thing is on sheet 1 the only pages that are reported on are the active ones, so there maybe 15 active pages but then 10 archived ones. Sheet 2 may generally have over 200 rows.

Also, how do you set up the search function like you have mentioned?

Thanks again