Index Match (No Match)

Im pulling in information from another sheet to the sheet in the image below and I cannot figure out how to only make the date show up when there is a match. I do not want "No Match" to appear.

=INDEX({picked up}, MATCH([Ticket #]@row, {ticket number}, 0))

Screen Shot 2022-10-31 at 1.56.23 PM.png

Find more posts tagged with

Accepted answers

L_123

=iferror(INDEX({picked up}, MATCH([Ticket #]@row, {ticket number}, 0)),""

All comments

L_123

=iferror(INDEX({picked up}, MATCH([Ticket #]@row, {ticket number}, 0)),""

NikkiOno

Thank you!

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.