The first 4 columns are what I have now, would like to create a calculated field that, per row, finds matching artist by artistID and puts its country in the new column. Tried RAW commands and they didn't seem to be the right way to go about this.

The use case might not quite make logical sense here as I've altered its nature to not violate company privacy. The actual nature of the data makes this make sense, so please ignore that minor fact