Find Multiple values and return value from another column

[pcarmour]

Hi,

I have a block of data that I want to find the Value "ISA " in Column "A" and return the values from Column "E" and "B".
On some days there can be multiple matches.
On the attached the results required are in B138:C142
I can't get Vlookup to work with multiple returns.

As always any help is very much appreciated.

I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)
Please see attached.

Test.xlsm

[pcarmour]

Obviously a difficult question so I have resolved it by using a different method. Thanks to those who looked anyway. Question now closed.

[mikerickson]

What was you solution?

I would have put
=INDEX($C:$C, SMALL(IF($A$1:$A$1000="ISA",ROW($A$1:$A$100),9999), ROWS($1:1)),1)&""
in a cell, entered it with Ctrl-Shift-Enter (Cmd+Return for Mac)
and dragged down.

[pcarmour]

Hi mikerickson, Thank you very much for your reply, Yes that works Brilliantly. My solution was much more long winded with separate formulas and data sorting, yours is much better.
Thank you.