Index formula only returns one instance

[PSI94]

Hi,

I've an index formula that I'm wanting to pull data thru from another sheet. I've found that it will only pull thru one instance, when in actuality there's 2.

Could anyone help in amending the formula?

=IFERROR(INDEX('Expected Results'!$A:$A,MATCH('Detailed Comparison'!AQ11,'Expected Results'!$CB:$CB)),"")

 

[KRice]

Try:

=IFERROR(FILTER('Expected Results'!$A:$A, 'Expected Results'!$CB:$CB='Detailed Comparison'!AQ11),"")

You may not need the IFERROR wrapper.

 

[PSI94]

Try:

=IFERROR(FILTER('Expected Results'!$A:$A, 'Expected Results'!$CB:$CB='Detailed Comparison'!AQ11),"")

You may not need the IFERROR wrapper.

thankyou!

 

[KRice]

I’m happy to help.