One Of Many Results Based On Cell Value

    Hi


    i have been using the IF but have ran out, so was hoping vlookup could help.


    I have a running total starting at 1 and going up to 21. (At each 3 a criteria will be triggered 3,6,9,12,15,18,21)


    Once a person gets to 3 i would like a cell to say "training".


    The figure would continue to be added to but "training" would still be displayed until a "yes" was place in a cell to say training had been done.
    Then the cell that had the word "Training" in it would be blank again until the figure reached six was reached and would then say "Code" this would then stay visible until a yes had been placed in the cell next to the other yes and would then be black until 9 was reached. And so on.


    This will continue at every 3 up to 21


    I'm not sure if its two criteria's or two different lookups


    I Hope you can help and this makes sense


    Don

    Re: One Of Many Results Based On Cell Value


    Thanks all
    I am Ok with lookup, but the problem i am having is i dont know how to get a lookup to look to two different cells at the same time.
    example is
    Lookup looks at A1 finds number 4 and returns "training" but if B1 has the word "Yes" then the lookup would return a blank. If B1 did not have "Yes" in it then A1 could be any number, "Training will always be returned. Then same for 6,9, and so on.


    Hope this explains


    Don

    Re: One Of Many Results Based On Cell Value


    Hmmm, I dont see that A1 has to be related to the result. Unless I have misread it. Take a look at the attached, which uses a simple lookup.


    HTH
    Ger

    Files

    training check_Solution.xls 21.5 kB – 87 Downloads

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

    Re: One Of Many Results Based On Cell Value


    Thanks Ger
    So Close to what i want. if you look at the file i posted. What i was trying to say was, if the numbers were not met the cell would be blank. even if you added a yes to any of the boxes.
    If the count is was 4 and i put a yes in the training box the main cell would then be blank. if i didnt it would stay as "Training"


    Try mine, but i didnt want to have to use all the "if's"


    does this make sense?


    Don

    Re: One Of Many Results Based On Cell Value


    I'd prefer


    =CHOOSE(INTEGER(SUM(A6:A15)/3)+1,"training","Code","2nd code","3d code","4th code","5th code","6th code","last code")


    You don't need A1
    You don't need K1,L1,M1 , etc


    dissect the formula so you can see what happens:


    in cel C20:
    = sum(A6:A15)
    in cell C21
    = C20/3
    in cell C22
    =integer(C21)
    in cell C23
    =choose(C21 +1,"training","Code","2nd code","3d code","4th code","5th code","6th code","last code")


    then fill A6 , A6 & A7 , A6 & A7 & A8, etc. and look what happens in cells C20 ... C23


    I suppose that every 3rd time there's a change in resulting value.

    Re: One Of Many Results Based On Cell Value


    Could i really be cheeky and ask you to show me in an excel file please.


    I know this is a big ask but im loosing a grasp on this.


    Many thanks in advanced


    don

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login