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