returning 3rd column based on 2 columns matching

[mcollier16]

I want to return column C of sheet1 when column A & B of sheet 2 match sheet 1... but there are multiple entries that i would like returned in separate columns based on column A & B matching (which may vary in qty)... I want each unique cell from column C, Sheet 1 to appear in the attribute name columns of sheet 2

I've never attempted something this large and i would greatly appreciate any pointers or help!!!


Sheet 2

AA AB AC AD AE AF AG AH AI AJ

Noun

Modifier

Attribute Name1

Attribute Value1

Attribute Name2

Attribute Value2

Attribute Name3

Attribute Value3

Attribute Name4

Attribute Value4

Attribute Name5

Attribute Value5

Attribute Name6

Attribute Value6

Attribute Name7

Attribute Value7

Attribute Name8

Attribute Value8

Attribute Name9

Attribute Value9

Attribute Name10

BEARING

SLEEVE

PLAIN

1-3/8"

1-5/8"

2-1/2"

OIL IMPREGNATED BRONZE

SLEEVE

COUPLING

INSERT

INSERT

THREADED

9/16"

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>

Sheet1

A B C

NOUN

MODIFIER

ATTRIBUTE

<tbody>
</tbody><colgroup><col><col><col></colgroup>

INSERT	TAB	SIZE
INSERT	TAB	MATERIAL
INSERT	TAB	COLOR
INSERT	TAB	TYPE
INSERT	TAB	ADDITIONAL INFORMATION
INSERT	THREADED	SIZE
INSERT	THREADED	LENGTH
INSERT	THREADED	ID
INSERT	THREADED	OD
INSERT	THREADED	THREAD SIZE
INSERT	THREADED	DRILL SIZE
INSERT	THREADED	TAP SIZE
INSERT	THREADED	MATERIAL
INSERT	THREADED	TYPE
INSERT	THREADED	ADDITIONAL INFORMATION

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[mcollier16]

I found this from another thread and was able to modify it to work as long as the cells aren't empty which is fine... but it still only gives me the first attribute in the list

=IF(Clean!AJ2="","",IFERROR(INDEX(Noun!$C:$C,SMALL(IF((Noun!$A:$A=Clean!$AD2)*(Noun!$B:$B=Clean!$AE2),ROW(Noun!$A:$A)),COLUMNS(Clean!$AJ2:AJ2))),""))