Automatically assigning music genres to artists based on existing entries

I have a spreadsheet with thousands of songs. Columns include Song Title, Artist, and Genre. Manually typing the genre for each new song is tedious. Is there a way to automate this so when I enter an artist name in a new row, Excel automatically fills the genre cell based on previous entries for that same artist? I have a mix of artists with one genre and some with multiple. Ideally, the formula would check the existing table data. Using Excel 365. What is the most efficient approach?