Index Collect Question

Sylvia Kay

I am trying to use Index Collect for the following - and I am stuck :-)

In the column "Validation NL" (upper table) I like to display the value of the column "Jira Status" if

1. the value in the column "Epic" = "GBT-704"
2. the value in the column "Req ID" matches the value in the column "MMP ID"

This is the formula I tried but it returns and #Incorrect Argument:

=INDEX({Jira MMP's Validation Results - Jira Status}, COLLECT("GBT-704", {Jira MMP's Validation Results - Epic}, [Req ID]@row, {Jira MMP's Validation Results - MMP ID}, 0))

This formula I tried and it returns #Unparseable

=INDEX(Collect({Jira MMP's Validation Results - Jira Status},{Jira MMP's Validation Results - Epic},"GBT-704"), Match([Req ID]@Row, {Jira MMP's Validation Results - MMP ID},0))

I am at the ends of my wits 🧐

Thank you for your ideas!

EvanShortreed

Hi Sylvia,

Go ahead and try this formula

=INDEX(COLLECT({Jira MMP's Validation Results - Jira Status}, {Jira MMP's Validation Results - Epic}, "GBT-704", {Jira MMP's Validation Results - MMP ID}, [Req ID]@row), 1)

EvanShortreed

Hi Sylvia,

Go ahead and try this formula

=INDEX(COLLECT({Jira MMP's Validation Results - Jira Status}, {Jira MMP's Validation Results - Epic}, "GBT-704", {Jira MMP's Validation Results - MMP ID}, [Req ID]@row), 1)

Sylvia Kay

Aww, thank you so much, but it also returns an error.

NicoLHC

@Sylvia Kay dis you resolve?

Paul Newcome

@Sylvia Kay Exactly what error message are you getting?

Sylvia Kay

Hi Paul, my mistake: The formula works! Thank you so very much!!!!

Sylvia Kay

MischeleSamson

Thank you soo much