I have an Excel 2003 workbook that contains several worksheets showing data
that I want to be able to add to one of the worksheets and use as a staff
roster. The information is imported from an Access 2003 mdb which is updated
on a daily basis.

My Staff Roster worksheet has column headers for Last Name, First Name,
Employee Number, Department, Hire Date, Seniority Date, and so on and so on.
I'm using the List feature to display selection choices in many of the
columns which pull data from one or more of the other worksheets.

When I select an employee number (say in Cell A1) form the EMP_List, I also
would like to pull the employees Last Name (from EMP_List to Cell B1) and
First Name (from EMP_List to Cell C1).

First can this be done and secondly, if so how would I go about this?

Mike

VLOOKUP formulas in B1 and C1 based upon the value in A1 drawing from a
table on EMP_List sheet.

See Debra Dalgleish's site for instructions and samples of VLOOKUP

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 11:51:02 -0700, watermt
wrote:

I have an Excel 2003 workbook that contains several worksheets showing data
that I want to be able to add to one of the worksheets and use as a staff
roster. The information is imported from an Access 2003 mdb which is updated
on a daily basis.

My Staff Roster worksheet has column headers for Last Name, First Name,
Employee Number, Department, Hire Date, Seniority Date, and so on and so on.
I'm using the List feature to display selection choices in many of the
columns which pull data from one or more of the other worksheets.

When I select an employee number (say in Cell A1) form the EMP_List, I also
would like to pull the employees Last Name (from EMP_List to Cell B1) and
First Name (from EMP_List to Cell C1).

First can this be done and secondly, if so how would I go about this?

Mike

Gord,
I tried referencing the Debra Dalgleish site you gave me but it comes up
with Page Cannot Be Displayed". Possible typo error?

Mike

"Gord Dibben" wrote:

VLOOKUP formulas in B1 and C1 based upon the value in A1 drawing from a
table on EMP_List sheet.

See Debra Dalgleish's site for instructions and samples of VLOOKUP

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 11:51:02 -0700, watermt
wrote:

I have an Excel 2003 workbook that contains several worksheets showing data
that I want to be able to add to one of the worksheets and use as a staff
roster. The information is imported from an Access 2003 mdb which is updated
on a daily basis.

My Staff Roster worksheet has column headers for Last Name, First Name,
Employee Number, Department, Hire Date, Seniority Date, and so on and so on.
I'm using the List feature to display selection choices in many of the
columns which pull data from one or more of the other worksheets.

When I select an employee number (say in Cell A1) form the EMP_List, I also
would like to pull the employees Last Name (from EMP_List to Cell B1) and
First Name (from EMP_List to Cell C1).

First can this be done and secondly, if so how would I go about this?

Mike

Did you double-click on the URL I posted?

I just now tried it and worked fine.

I did have a problem a couple hours ago getting to Debra's site.


Gord

On Wed, 11 Mar 2009 14:35:01 -0700, watermt
wrote:

Gord,
I tried referencing the Debra Dalgleish site you gave me but it comes up
with Page Cannot Be Displayed". Possible typo error?

Mike

"Gord Dibben" wrote:

VLOOKUP formulas in B1 and C1 based upon the value in A1 drawing from a
table on EMP_List sheet.

See Debra Dalgleish's site for instructions and samples of VLOOKUP

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 11:51:02 -0700, watermt
wrote:

I have an Excel 2003 workbook that contains several worksheets showing data
that I want to be able to add to one of the worksheets and use as a staff
roster. The information is imported from an Access 2003 mdb which is updated
on a daily basis.

My Staff Roster worksheet has column headers for Last Name, First Name,
Employee Number, Department, Hire Date, Seniority Date, and so on and so on.
I'm using the List feature to display selection choices in many of the
columns which pull data from one or more of the other worksheets.

When I select an employee number (say in Cell A1) form the EMP_List, I also
would like to pull the employees Last Name (from EMP_List to Cell B1) and
First Name (from EMP_List to Cell C1).

First can this be done and secondly, if so how would I go about this?

Mike

Gord,
Thanks for the info, yes I too had a hard time connecting yesterday to
Debra's site. But this morning it worked just fine. I went through and
watched her video which really helped me crerate the first part of my
VLookup. Now, I'm stuck on modifying the formula to grab two pieces of
information.

here's my current working formula:
=VLOOKUP(C2,EMPLOYEE_Info!TECHNOLOGY_PROD_GLOBAL_E MPLOYEE_v,4,FALSE)

This works to pull the employees last name to the Last Name column (A1), but
I'd also like this formula to retrieve the First Name and place it in the
First Name column (B1). Would I use the AND function for this in the above
formula?

Thanks,
Mike


"Gord Dibben" wrote:

Did you double-click on the URL I posted?

I just now tried it and worked fine.

I did have a problem a couple hours ago getting to Debra's site.


Gord

On Wed, 11 Mar 2009 14:35:01 -0700, watermt
wrote:

Gord,
I tried referencing the Debra Dalgleish site you gave me but it comes up
with Page Cannot Be Displayed". Possible typo error?

Mike

"Gord Dibben" wrote:

VLOOKUP formulas in B1 and C1 based upon the value in A1 drawing from a
table on EMP_List sheet.

See Debra Dalgleish's site for instructions and samples of VLOOKUP

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 11:51:02 -0700, watermt
wrote:

I have an Excel 2003 workbook that contains several worksheets showing data
that I want to be able to add to one of the worksheets and use as a staff
roster. The information is imported from an Access 2003 mdb which is updated
on a daily basis.

My Staff Roster worksheet has column headers for Last Name, First Name,
Employee Number, Department, Hire Date, Seniority Date, and so on and so on.
I'm using the List feature to display selection choices in many of the
columns which pull data from one or more of the other worksheets.

When I select an employee number (say in Cell A1) form the EMP_List, I also
would like to pull the employees Last Name (from EMP_List to Cell B1) and
First Name (from EMP_List to Cell C1).

First can this be done and secondly, if so how would I go about this?

Mike

If you want information in another cell, you need a formula in that cell, not a
modification to this one. I would assume something like this:

=VLOOKUP(C2,EMPLOYEE_Info!TECHNOLOGY_PROD_GLOBAL_E MPLOYEE_v,5,FALSE)


watermt wrote:
Gord,
Thanks for the info, yes I too had a hard time connecting yesterday to
Debra's site. But this morning it worked just fine. I went through and
watched her video which really helped me crerate the first part of my
VLookup. Now, I'm stuck on modifying the formula to grab two pieces of
information.

here's my current working formula:
=VLOOKUP(C2,EMPLOYEE_Info!TECHNOLOGY_PROD_GLOBAL_E MPLOYEE_v,4,FALSE)

This works to pull the employees last name to the Last Name column (A1), but
I'd also like this formula to retrieve the First Name and place it in the
First Name column (B1). Would I use the AND function for this in the above
formula?

Thanks,
Mike


"Gord Dibben" wrote:

Did you double-click on the URL I posted?

I just now tried it and worked fine.

I did have a problem a couple hours ago getting to Debra's site.


Gord

On Wed, 11 Mar 2009 14:35:01 -0700, watermt
wrote:

Gord,
I tried referencing the Debra Dalgleish site you gave me but it comes up
with Page Cannot Be Displayed". Possible typo error?

Mike

"Gord Dibben" wrote:

VLOOKUP formulas in B1 and C1 based upon the value in A1 drawing from a
table on EMP_List sheet.

See Debra Dalgleish's site for instructions and samples of VLOOKUP

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 11:51:02 -0700, watermt
wrote:

I have an Excel 2003 workbook that contains several worksheets showing data
that I want to be able to add to one of the worksheets and use as a staff
roster. The information is imported from an Access 2003 mdb which is updated
on a daily basis.

My Staff Roster worksheet has column headers for Last Name, First Name,
Employee Number, Department, Hire Date, Seniority Date, and so on and so on.
I'm using the List feature to display selection choices in many of the
columns which pull data from one or more of the other worksheets.

When I select an employee number (say in Cell A1) form the EMP_List, I also
would like to pull the employees Last Name (from EMP_List to Cell B1) and
First Name (from EMP_List to Cell C1).

First can this be done and secondly, if so how would I go about this?

Mike