Vlookup
 

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

Vlookup
 

See if this helps:

http://contextures.com/xlFunctions02.html

Biff

"Patrick Simonds" wrote in message
...
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

Vlookup
 

Did you get a working answer to this one? If not let me know and I can help
you out (I believe!)

"Patrick Simonds" wrote:

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