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.

Find more posts tagged with

Sheets

Formulas

Reports

Support

Cell linking

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.