Excel cell to populate from live sharepoint list

I have a sharepoint list for colleague assessments. Each time they are assessed we rate our colleagues from 1-4 on each of their different tasks. this is done on sharepoint.

what i would like to do is ask excel to look at the lists and display the average rating for each colleague on each process.

I was thinking of something like a IF AND formula that says 'check the sharepoint list and if the colleagues name is X AND the process is Y, work out the average in the ratings column.

I could do this if i exported the list to sharepoint, but as far as i know, when i update the list, it wouldnt update the export and so i would need to keep exporting. 

Is there a way to create this desired outcome live, with minimal maintenance?

TIA