Function to pick all matches associated with certain entry (Modify Vlookup or alternative)

[Taisir]

Dear All
In the attached sample file, I need a function to insert in R2 and copy across to U2 and down, to pick up all the values )up to four) associated with the ISSN under the Quartile heading.

I was not able to use Vlookup since it picks the first value it encounters.

All the best Taisir

[FDibbins]

See if this ARRAY formula will work for you...
Q2=IFERROR(INDEX($F$2:$F$36,SMALL(IF($D$2:$D$36=$P2,ROW($D$2:$D$36)-2),COLUMNS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[Taisir]

Dear FDibbin,
For some reason, the formula dis not produce the desired/intended outcome as indicated in the attached.
What Am I doing wrong. take care

[FDibbins]

My apologies, try this isntead (slight modification), still CSE...
=IFERROR(INDEX($F:$F,SMALL(IF($D$2:$D$36=$P2,ROW($D$2:$D$36)),COLUMNS($A$1:A1))),"")

[Taisir]

Many thanks Fdibbins for the magical formula. Taisir

[FDibbins]

Happy to help, thanks for the feedback