Can I use Join(Collect with multiple entry drop down?

Hi, I have a formula below that looks at 2 sheets and when the "PLY-Code Needed" from the 1st sheet finds a match on sheet 2, it gives me the "Description" from sheet 2. It works fine but as shown in row 131, there are 2 "PLY-Codes" and this makes this unable to pul the info. Any advice?

Here is my Current formula:

=JOIN(COLLECT({Ply List With Codes Range 1}, {Ply List With Codes Range 2}, =[PLY-Code Needed]@row ), " / ")

Find more posts tagged with

Accepted answers

All comments

Darren Mullen

@Brandon Morales Try this:

=JOIN(COLLECT({Ply List With Codes Range 1}, {Ply List With Codes Range 2}, has([PLY-Code Needed]@row,@cell ) ), " / ")

Brandon Morales

coming up unparseable…

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.