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

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