IF, INDEX, MATCH formula help

I need to add an IF statement into an INDEX MATCH formula that pulls the system size of a column if it is not blank.

This formula will be on sheet #1 and needs to be an IF, INDEX, MATCH. Sheet #2 will have the actual system size column and Sheet #3 will have the target system size column. The formula should pull from sheet #2 (actual size) but if no value is present, then it should pull from sheet #3. All sheets have a column, Project ID, which is what we will INDEX MATCH with.

Is it possible to put this all in a formula?

Find more posts tagged with

Formulas

Accepted answers

DKazatsky2

Hi @swaldon2,

This should give you what you're after.

=IF(NOT(ISBLANK(INDEX({Actual Size}, MATCH([Project ID]@row, {Project ID 1})))), INDEX({Actual Size}, MATCH([Project ID]@row, {Project ID 1})), INDEX({Target Size}, MATCH([Project ID]@row, {Project ID 2})))

{Project ID 1} and {Project ID 2} are cell references to the project id in Sheet 2 and Sheet 3.

Hope this helps,

Dave

All comments

DKazatsky2

Hi @swaldon2,

This should give you what you're after.

{Project ID 1} and {Project ID 2} are cell references to the project id in Sheet 2 and Sheet 3.

Hope this helps,

Dave

swaldon2

@DKazatsky2 That works, 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.