|
This is probably a fairly simple question, but I'm not really sure how to google for it. I work at a college radio station, and for our regular rotation, our DJs fill out a google spreadsheet with the time a song was played, the name of the song, and the artist that song is by, as well as +/- feedback from callers. We currently use one charting service, CMJ, who we send a summary of this data too. We are looking to use another charting service as well, but they would require our whole setlist, including album titles, which we don't currently record. We do have our albums in a separate spreadsheet, so my question is, how would I go about filling out an "album" column on the setlist automatically? I'm open to using Excel, Google Sheets, or really anything that would take CSV data.
|
# ? Jan 18, 2017 20:06 |
|
|
# ? May 6, 2024 23:55 |
|
You're probably looking for something like vlookup. My understanding of what you want is that you have one excel list that has song title and another list that has song title + album title, correct? If that's the case then you can use vlookup.
|
# ? Jan 19, 2017 00:22 |
|
Stanley Pain posted:You're probably looking for something like vlookup. Vlookup is exactly what I was looking for, thanks!
|
# ? Jan 19, 2017 01:08 |