Index/Match Question

I have a formula need that I hope you all can help with.

I have two sheets that have a unique identifier. What I'd like to have happen is when the identifiers match between the two sheets, then data in one columm in a sheet, populates into a column in a different sheet.

Screenshot 2024-06-11 at 12.46.54 PM.png

Screenshot 2024-06-11 at 12.47.01 PM.png

So when the MHID's match between the two sheets, we want the list of deliverables in the top sheet to populate in the bottom sheet. I'm struggling to get the equation to work.

Please help!

Find more posts tagged with

Accepted answers

Mark.poole

@Becky Wardlaw

Be sure to change the references to match yours.

=Index({Description},Match(MHID@row,{MHID},0))

See how this works out for you.

All comments

Mark.poole

@Becky Wardlaw

Be sure to change the references to match yours.

=Index({Description},Match(MHID@row,{MHID},0))

See how this works out for you.

Mark.poole

@Becky Wardlaw

I just re read what it is your wanting. Sadly multi select items can not be done in a formula. You can how ever make it show text values. using HAS functionality. how ever this will be a REALLY long formula depending on how many Deliverables you have in your multi select dropdown.

Becky Wardlaw

Thank you! My thinking was backwards on the formula!!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.