formulas to reference sheet in multiple lines
Is it possible to bring information to a sheet from a reference sheet column but have it list the returned information out in separate rows?
I have a source sheet with many rows that are sorted by status. I want to list out the job numbers AND the job name in another sheet, ideally side by side one on each row. I would use a report for this, but there is information I need to also add to the sheet that isn't on the source sheet.
This has been a bit of a mystery for me. I wasn't sure if there was a formula I could use to find and collect.
Help Article Resources
Check out the Formula Handbook template!