Lookup and output multiple values from table

Hi guys,
I've shopped a couple of forums for a solution and even consulted the dark web (Google page 2 and 3 ) but wasn't able to find what I am looking for. Here's a quick description of my problem:

Column A = Equity, Bonds, Credit, Collateral, FX Hedge, ... [Asset class in general]
Column B = Future, Option, Bondoption, Cash... [Type of instrument]
Column C = Combination of A&B (e.g. EquityFuture, BondsBondoption, BondsFuture, ...) [functions as a identifier to get what I want as easy as possible]
Column D = Bloomberg ticker (e.g. VGM6 Index, ESM6 Index, RXM6 Comdty)
Column E = Quantity

What do I want: If column C = EquityFuture, return every value from column D and E for which this is true.

I know it has to do with INDEX, MATCH and OFFSET but I don't seem to get to a solution that works.

Would be grateful if someone could look into this and help me.

Try

For Column D entries

=IFERROR(INDEX($D$2:$D$1000,SMALL(IF($C$2:$C$1000="EquityFuture",ROW($D$2:$D$1000)-ROW($D$2)+1,""),ROWS($D$2:D2))),"")

For Column E entries

=IFERROR(INDEX($E$2:$E$1000,SMALL(IF($C$2:$C$1000="EquityFuture",ROW($E$2:$E$1000)-ROW($E$2)+1,""),ROWS($E$2:E2))),"")


Enter both with Ctrl+Shift+Enter

Copy down until you get blank cells

Thanks John. Worked flawlessly.

Thank you for the feedback.

Could you please mark thread as solved ("Thread Tools" at top of first post)

Hi another question that is probably related but I can't get the condition / equation right:
Column F = expiry date / maturity date

IF column A = Equity, return Bloomberg Ticker for every position that has an expiry date 21 days from today

Any ideas?

Can you please post a sample file (not image). how does "Equity" in A relate (if at all) to "EquityFuture" in C?

Example1.xlsx

Here you go John.

In I8

=IFERROR(INDEX($D$2:$D$4,SMALL(IF(($A$2:$A$4=I$7)*($F$2:$F$4=TODAY()+21),ROW($A$2:$A$4)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

Enter with Ctrl+Shift+Enter