Here is my dilemma.

I have 20,575 rows on my spreadsheet. I want to be able to create a
function or macro to populate a field based on the doctor's ID number.

There are about 200 doctor's ID numbers.

Thanks.