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