PDA

View Full Version : [SOLVED] Find Multiple values and return value from another column



pcarmour
11-28-2013, 05:40 AM
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.

10878

pcarmour
11-28-2013, 12:15 PM
Obviously a difficult question so I have resolved it by using a different method. Thanks to those who looked anyway. Question now closed.

mikerickson
11-28-2013, 10:55 PM
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
11-29-2013, 01:04 AM
Hi mikerickson (http://www.vbaexpress.com/forum/member.php?10706-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.