RE: VLookUP formula help!

Tech-Archive recommends: Speed Up your PC by fixing your registry

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~
.

Quantcast