Suppose a Sheet/Workbook has a list of Emp No & Names.

Now I have to get the name of a person by giving the Emp No in another sheet/Workbook referring the above sheet/workbook.