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

Originally Posted by Khalidngo

Hi,

Try this in data sheet, cell B2:
=VLOOKUP(Data!A2,Master!$A$2:$B$10,2,0)

or:

=INDEX(Master!$B$2:$B$10,MATCH(Data!A2,NameList,0))

copy down...

Blessing

AMAZING... QUICK... SOLUTION !!!!!

Thanks a lot.

Thanks a lot for your quick solution.