Lookup/List function???

**sdj1704** · 07-22-2009, 11:11 AM

I am trying to create a simple to maintain PTO register.
I have one sheet that will have the following:
Name
Date
Hours
Each line will represent an employee and the date in which they are taking as leave along with the number of hours taken
A second sheet will have the employees names along with their entitlement for the year (in hours)

I am trying to create a third sheet that will be a statement showing what their entitlement is, which days they have taken and what their remaining entitlement is.

Is there a formula that will "list" the line items from the first sheet? incorporating a vlookup as I want to be able to either type or select the employee from a drop down menu so that I can have one sheet for all.

Thanks in advance

**modytrane** · 07-22-2009, 11:15 AM

attach sample files of what you have in mind in terms of formats, columns, sample data and expected results.
It will be easy for someone to understand your requirements and help you.
modytrane

**sdj1704** · 07-22-2009, 11:42 AM

Thanks
Please see the attached file

**modytrane** · 07-23-2009, 08:39 AM

see the attached file.
in the Statement, cell E13 is a drop down menu.
you can select the employee name and it will fill the yellow area with info you want.
hope it helps.
modytrane

**sdj1704** · 07-23-2009, 12:28 PM

Awesome.... thanks Modytrane!!
Most appreciated

**sdj1704** · 07-23-2009, 02:48 PM

Hate to be more trouble but there is something not quite right with the results.
If you look at the dates on the register tab, you can see that the august dates are coming through differently on the statement.
This is happening with a number of people.

I tried to see if it was a formatting error, but didnt find anything.

Any suggestions?
Thanks