Check text in adjacent cell and accordingly fill text from master reference

Hi,

I'm new to this forum and hoping for some solution to autofill TEXT using some formula.

I tried my best but Sorry am not able to describe my problem using proper MS Excel terminology. But I will keep learning

So attached is my sample file. In the Master Worksheet, I have defined NameList and item related to each name.

Next in the datasheet, when I select any name from the drop-down NameList, I want a FORMULA to automatically pick-up the item related to that name and thus fill that empty cell with text.

Thanks in advance for your help.

BCM