Auto-fill genre in Excel based on artist name?

I have an Excel sheet with a long list of all my liked songs from Spotify. The columns include things like:

Song Name | Artist | Album | Genre

Right now I’ve been manually typing the genre for each artist, but I’ve realized I’ve already entered the genre for many of the same artists elsewhere in the sheet. I’m hoping there’s a way to automatically fill the genre for songs by the same artist.

Example:

Song | Artist | Genre
Song A | Artist 1 | Indie Rock
Song B | Artist 2 | Pop
Song C | Artist 1 | (blank)

Ideally, Song C would automatically fill Indie Rock because Artist 1 already has that genre listed somewhere else in the sheet.

Is there a formula or method that can look for the same artist name and return the genre that already exists in another row?

The sheet is a few thousand rows, so anything that avoids manually re-typing genres would save a ton of time.

Thanks!