Hunter Childress
Member
See attached test data.
I need help with a formula that will pull the value from the data set on the right based on the the text in cell B1 BUT, if the value is ZERO, then I want it to pull from the next year, and if that value is zero, then I want to pull the next year.
Based on the text in B2, If I am looking for 17LP data, it would pull 17LP but if there is 0, then it will pull 18LP. In addition, if I change the year in B2 to 18LP, it will only pull from 18LP unless there is a 0, then it will go to 19LP.
Thanks in advance!
-Hunter
I need help with a formula that will pull the value from the data set on the right based on the the text in cell B1 BUT, if the value is ZERO, then I want it to pull from the next year, and if that value is zero, then I want to pull the next year.
Based on the text in B2, If I am looking for 17LP data, it would pull 17LP but if there is 0, then it will pull 18LP. In addition, if I change the year in B2 to 18LP, it will only pull from 18LP unless there is a 0, then it will go to 19LP.
Thanks in advance!
-Hunter
Attachments
Last edited: