Hello all,
I was working on a spreadsheet and got stumped on this problem. I have a list of processes that I labeled either main or iteration. Each process had been assigned a specific value.
I used INDEX/MATCH to lookup a input value and determine whether it is "main" or "iteration"
Now I am trying to output the value(s) of "iteration" for that "main" and vise versa in the named process. I was using IF(C3="main", C3, ... I think I need offset after this but I am unsure how to apply it. If the input value is a main, it should output all "iteration" values until it reaches the next "main" I would appreciate any help or advice. Thank you!
Ray
Bookmarks