• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vlookup onto formulas

M

Marko@Mera

New Member
Hi guys,

I am trying to create a file where I can track the untaken vacation days of each employee in order to calculate the vacation accrual.
I have 4 scenarios that I need to cover with formulas.
For each Scenario I need a different formula.
I want to avoid combining all 4 formulas as this would be way too long and it didnt work at all when i tried it once. the individual formulas do work though.

My idea is to create a vlookup to a given variable and then take the formula needed for that specific variable. so if cell b2 is "A" then take the formula for "A"(the formula is on a different worksheet)

When i do the vlookup onto that place where the formula is, it will give me the result of the formula rather than the formula itself.

Anybody has an idea how to solve this?

Thanks
 
Hi ,

I am sorry but I am nowhere near understanding what you want to do.

Instead of discussing your formulae , if you can explain what your requirement is , it will help.

Narayan
 
I have 4 scenarios in my file, "A", "B", "C" and "D".
All scenarios require a different calculation.
instead of creating a formula that covers all 4 scenarios at once, i would like to decide for each scenario to use a formula that is defined for this specific Scenario.

hope that helps
 
Hi ,

But what is so complicated about the scenario ?

There are only 4 dates involved , the START DATE and the END DATE for the employee , and the START DATE and the END DATE for the period.

If the employee started work before this year , then the START DATE for the employee is January 1 , 2016.

If the employee started work sometime this year , then the START DATE for the employee is date they started working.

If the employee is not leaving or has not left this year , then the END DATE for the employee is December 31 , 2016.

If the employee is leaving or has left this year , then the END DATE for the employee is the date they are leaving / will leave.

The START DATE and the END DATE for the periods are the dates mentioned in rows 2 and 3 of each column.

Based on the appropriate dates , the calculations should be the same.

Narayan
 
You must log in or register to reply here.
Back
Top