I am looking for someone to match data on an excel spreadsheet.
Basically, I have a list of approx. 700 people who signed up for an event and filled in their Bike Model through an open text field. I have another list of Bike Models with their appropriate IDs (that we use in our own database).
In the end, I need the full list of those who signed up for the event, with the appropriate bike model ID (replacing what they typed into an open field, and therefore in perfect form for us to append in our database).