Conditional lookup to create a list from a list
This seems like a very rudimentary ask but I am stumped. Hope someone can help.
Can anyone please suggest a column formula that can bring values over from a sheet based on a conditional lookup to an adjacent cell and list them contiguously on another sheet?
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!