RE: VLookUP formula help!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Here is my little calculator:

Select Range: Certified 10 Month<<<This is a drop down box to choose the
type of employee I am calculating for.
Enter Start Date: 8/7/2008
Days Worked: 200
Minus Missed Days:







Total Work Days Possible(-holidays/breaks)
ALL 12 Month = 245
Certified 10 Month = 209
Certified 11 Month = 229
Certified 9-Month = 172
Haskell (Year-Rnd)= 212
Non-Certified 10 Mth = 209

Add Snow Days: 1
Minus Holiday/Break 16


"Shane Devenshire" wrote:

Hi,

Please show us some sample data in the lookup table and then explain, with
respect to that sample, what you mean by "count forward from that date the #
of cells with text in them ("Holiday") and then subtract that from the value
it retrieved"
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Denise" wrote:

I created a formula to reference a drop-down menu & then based on the
value...get value from the selected Lookup Table (column #2). Here's the
formula:

=IF(L2="Certified 10 Month",VLOOKUP(L3,Ten, 2), IF(L2="All 12
Month",VLOOKUP(L3,StartDate, 2), IF(L2="Non-Certified 10
Mth",VLOOKUP(L3,NonCert, 2), IF(L2="Certified 11 Month",VLOOKUP(L3,Eleven,
2),IF(L2="Haskell (Year-Rnd)",VLOOKUP(L3,Haskell, 2),IF(L2="Certified
9-Month",VLOOKUP(L3,Nine, 2))))

What I ultimately need this formula to do is to search the chosen lookup
table column based on the entered date and count forward from that date the #
of cells with text in them ("Holiday") and then subtract that from the value
it retrieved. I am trying to get an accurate count of days an employee will
work - holidays.

Any help appreciated~
.

Relevant Pages

  • Re: Still Struggling...
    ... In my opinion it should be in separate tables regardless. ... Then you would use DeptID and SubjectID as foreign keys in other tables. ... in the employee table and live with a few empty address fields. ... that will basically just be "lookup" tables. ...
    (microsoft.public.access.gettingstarted)
  • Re: Drop Down on Table
    ... I didn't want you to create a lookup in the table; ... What you really need is just Employee ID, ... When I highlight the Last Name then to Lookup, I put Display Control ... Joan Wild wrote: ...
    (microsoft.public.access.security)
  • Access Database Appointment Help
    ... Primary Key - Client ID ... Table 2 (Lookup ClosedDays) has the following characteristics: ... Table 3 (Lookup Employee) has the following characteristics: ... I need help with the user form - I really want it to be a secure database, ...
    (microsoft.public.vc.database)
  • Re: Missing Fields from report
    ... group for references to the second commandment with very informative results. ... the useful lookup table. ... when a employee is selected in the form's combo box. ... is perfectly normal to display that information in unbound ...
    (microsoft.public.access.reports)
  • Re: Lookup based on a date being between a range
    ... mary was in column a1 and b2 would be the pay rate or dollar amount in sheet1. ... I want to lookup the correct hourly rate of an employee in a table. ... I want to lookup the correct Rate for Mary based on the date she worked. ...
    (microsoft.public.excel.worksheet.functions)