Just as the title says. I play a Bard, College of Lore. At 6th character level I will be able to pick up two spells, of up to 3rd spell level, from any class. I know we will be on the long-term adventure with no easy way to get food and drinks. Goodberries could make it much easier for us, but I do not want to "waste" a 3rd level spell known for a 1st level spell if there is something of more power available to me.
Preference is for material from Player’s Handbook and Xanathar’s Guide To Everything as it is automatically allowed. If there are multiple spells that meet the requirement, the one with the widest utility wins. If there are none, the highest level and biggest utility are the factor.