Displaying a Valid Production Task
I would like to ask for help on how I can make a formula that show this function. If value of column E5 is "READ EMAIL", check E6 downward (E6, E7, E8, E9, E10, so on) for any valid Task such as "WASH DISHES" or "EATING" or "PLAYING" or "SURFING" or "SLEEPING". If any of those valid Task appear, display in column I5 the first valid task. But if E5 is "APPLE" or "BANANA" or "TOMATO" or "ORANGE" or "MANGO" or "PINEAPPLE" or "GRAPES" or "STRAWBERRY" or "MELON", check column E4 upward (E4, E3, E2 and so on) for any valid task such as "WASH DISHES" or "EATING" or "PLAYING" or "SURFING" or "SLEEPING". If any of those valid task appear, display the Valid task before the fruit appear in I5.
Hope there is anyone who can help me with this.
Thank you very much!
chocobo
I would like to ask for help on how I can make a formula that show this function. If value of column E5 is "READ EMAIL", check E6 downward (E6, E7, E8, E9, E10, so on) for any valid Task such as "WASH DISHES" or "EATING" or "PLAYING" or "SURFING" or "SLEEPING". If any of those valid Task appear, display in column I5 the first valid task. But if E5 is "APPLE" or "BANANA" or "TOMATO" or "ORANGE" or "MANGO" or "PINEAPPLE" or "GRAPES" or "STRAWBERRY" or "MELON", check column E4 upward (E4, E3, E2 and so on) for any valid task such as "WASH DISHES" or "EATING" or "PLAYING" or "SURFING" or "SLEEPING". If any of those valid task appear, display the Valid task before the fruit appear in I5.
Hope there is anyone who can help me with this.
Thank you very much!
chocobo
