mcollier16
New Member
- Joined
- May 18, 2016
- Messages
- 2
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
<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
<tbody>
</tbody><colgroup><col><col><col></colgroup>
<tbody>
</tbody><colgroup><col><col><col></colgroup>
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>