I have a 1000 Row excel data sheet with client names.

One column is for : " Title" and the other column is "Role"

I am looking to make it so if Column Titile Row 3 says " DSD" then Column Role Row 3 says "Dentist"

And I'm looking for a rule that would be easily applied to 1000 clients.

I have NO idea how to do VBA

Thanks in advance!