Dear Reader,
I'm using this formula:
{=IFERROR(INDEX('Input (All Tickets)'!$B$2:$B$307;SMALL(IF(ISNUMBER(MATCH('Input (All Tickets)'!$R$2:$R$307;$C$3;0));MATCH(ROW('Input (All Tickets)'!$R$2:$R$307);ROW('Input (All Tickets)'!$B$2:$B$307));"");ROWS($A$4:$A4)));"")}
It's showing me the correct results based on C3. However, I'm trying to add another criteria to fine tune the results. The criteria value is placed in E3, with the search range being 'Input (All Tickets)'!$D$2:$D$307'.
So I basicly need to add (MATCH('Input (All Tickets)'!$D$2:$D$307;$E$3;0) to this formula so it only shows the results if both the condition in C3 and E3 are met.
I'm having trouble figuring out how to do that. Any help is much appreciated.
Kind regards,
Steve
I'm using this formula:
{=IFERROR(INDEX('Input (All Tickets)'!$B$2:$B$307;SMALL(IF(ISNUMBER(MATCH('Input (All Tickets)'!$R$2:$R$307;$C$3;0));MATCH(ROW('Input (All Tickets)'!$R$2:$R$307);ROW('Input (All Tickets)'!$B$2:$B$307));"");ROWS($A$4:$A4)));"")}
It's showing me the correct results based on C3. However, I'm trying to add another criteria to fine tune the results. The criteria value is placed in E3, with the search range being 'Input (All Tickets)'!$D$2:$D$307'.
So I basicly need to add (MATCH('Input (All Tickets)'!$D$2:$D$307;$E$3;0) to this formula so it only shows the results if both the condition in C3 and E3 are met.
I'm having trouble figuring out how to do that. Any help is much appreciated.
Kind regards,
Steve