This one should be an easy one!
I have a file that gives me a cross match based on style and month.
However, if the user chooses say, March for example, I want the formula to add January and February as well.
I know there is a along complicated way to do this where I add Index and Matches and maybe several nested if-thens but if I could get one formula, that would be great!
So Basically instead of =index(a1:z1000,match(Style,a1:a1000,0),match("Jan",a1:z1,0) + index(a1:z1000,match(Style,a1:a1000,0),match("Feb",a1:z1,0)
have it say something like
=index(a1:z1000,match(Style,a1:a1000,0),match({"Jan","Feb"},a1:z1,0).
Thanks
Bookmarks