Combined Match Values with cross-sheet matching

Hello,

I am attempting to match to two different sheets. Essentially if the linked ticket column matches the risk register ID I want to use the first formula and if it matches the BRD (second formula) I want it to use that formula. I am attempting to combine these into what I would assume would be an if statement but wanted to throw it out here and see if anyone had any easy suggestions.

Note: Both formulas below are working as expected I would just like to combine them into 1 formula.

Formula 1: If the linked ticket column matches (ex: RA-01) then I want it to show the risk.

=INDEX({PMO-### Risk Assessment Range 1}, MATCH($[Linked Ticket/Risk]12, {Risk IDs}, 0), MATCH(Risk$1, {Column Headers}, 0))

Formula 2: if the BRD# matches then I want to show the BRD (ex: BRD-01)

=INDEX({PMO-### - Business Requirements Document Range 1}, MATCH($[Linked Ticket/Risk]@row, {PMO-### - Business Requirements Document Range 2}, 0), MATCH([Requirement description]$1, {Column Headers - BRD}, 0))

Find more posts tagged with

Accepted answers

Leibel S

@Kyle Jarrett

Seems like IFERROR() would solve this for you:

=IFERROR(INDEX({PMO-### Risk Assessment Range 1}, MATCH($[Linked Ticket/Risk]12, {Risk IDs}, 0), MATCH(Risk$1, {Column Headers}, 0)),INDEX({PMO-### - Business Requirements Document Range 1}, MATCH($[Linked Ticket/Risk]@row, {PMO-### - Business Requirements Document Range 2}, 0), MATCH([Requirement description]$1, {Column Headers - BRD}, 0)))

All comments

Leibel S

@Kyle Jarrett

Seems like IFERROR() would solve this for you:

Kyle Jarrett

@Leibel S - This did, in fact work. Thank you so much. Knew it would be easier to just ask instead of messing with it.

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.