I think I need to use Vlookup, but I do not understand it.

I have a column in my worksheet where names are placed. I have another
workbook which is also open (EmployeeList.xls) with a worksheet
(Employee_List) with a table of all employees and there associated
information.

What I need is something which will look at Column A of my worksheet and
then go to the other workbook, find that value (Name) and return the
contents of column F