Return MULTIPLE corresponding values for TWO Lookup Value, Horizontally, in one Row

[windycity_SP500]

Similar to this link(reference the bottom)- I am trying to return multiple corresponding values with two look up conditions, horizontally, in one row. Then I can apply it down other rows.

Not sure how to go about this- I have been stuck for days. I provided a sample below:

ID	Name	Qty
A	Clark	9​
a	Ann	11​
p	Bob	50​
p	Bob	65​
a	Joe	66​
o	Ty	4​
A	Joe	4​
b	Joe	80​

What I need is here:

Based on Name and ID shown below, I need to fetch the corresponding qty for those look up conditions. For instance, Joe with ID 'A', should output QTY 66 and 4.

Name	ID	qty	qty	qty	qty	qty	qty	qty	etc…
Joe	a
bob	B

I am able to return such value for one condition, but that isn't the result I need. Any help would be greatly appreciated. Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
How about

ZFluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	ID	Name	Qty			Name	ID	qty	qty	qty	qty	qty	qty	qty	etc…
2	A	Clark	9			Joe	a	66	4
3	a	Ann	11			bob	p	50	65
4	p	Bob	50			joe	b	80
5	p	Bob	65
6	a	Joe	66
7	o	Ty	4
8	A	Joe	4
9	b	Joe	80
Data

Cell Formulas
Range	Formula
H2:O4	H2	=IFERROR(INDEX($C$2:$C$9,AGGREGATE(15,6,(ROW($C$2:$C$9)-ROW($C$2)+1)/(($B$2:$B$9=$F2)*($A$2:$A$9=$G2)),COLUMNS($H1:H1))),"")

 

[windycity_SP500]

Hi & welcome to MrExcel.
How about

ZFluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	ID	Name	Qty			Name	ID	qty	qty	qty	qty	qty	qty	qty	etc…
2	A	Clark	9			Joe	a	66	4
3	a	Ann	11			bob	p	50	65
4	p	Bob	50			joe	b	80
5	p	Bob	65
6	a	Joe	66
7	o	Ty	4
8	A	Joe	4
9	b	Joe	80
Data

Cell Formulas
Range	Formula
H2:O4	H2	=IFERROR(INDEX($C$2:$C$9,AGGREGATE(15,6,(ROW($C$2:$C$9)-ROW($C$2)+1)/(($B$2:$B$9=$F2)*($A$2:$A$9=$G2)),COLUMNS($H1:H1))),"")

Thank you so much! This is what I needed. I appreciate it.

 

[Fluff]

You're welcome & thanks for the feedback