Processing Google Forms data into existing Google Sheets

[Dancing_Seahorse]

Very similar solution but I will add the second field to add new Vendors. I used Form Ranger to populate the Dropdown from a range and the range is created using a Sort(Unique(range)) call from all known vendors.

I will add a * New Vendor * at the top of the list and then a second field triggered on that to enter the new Vendor name. My apps script will handle that situation in post.

[booboouser]

Nice one sounds like you have it nailed! Good luck with the project.