formulas to reference sheet in multiple lines

Nicolette Marinos

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.

Andrée Starå

Hi @Nicolette Marinos

I hope you're well and safe!

Can you share some screenshots/mockups of how you'd like it to work? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!