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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!