Hi and welcome to the forum

If you do indeed what a macro for this, I will leave your post here.

But you could do this with a very simple vlookup(). All you need is to have a list of all the relevant info, and the vlookup() will find it for you.

=vlookup("drop-down-range",range-of-your-data,column-number-to-search-in,0)
=vlookup(A5,$K$1:$M$20,2,0)