monsierexcel
New Member
- Joined
- Nov 19, 2018
- Messages
- 29
hey all, I have a question about using index/match to return a value
<colgroup><col span="5"></colgroup><tbody>
</tbody>
How would i return Title 4 from SKU1 and Source2?
this is in a worksheet called "data"
this is what i have tried so far but cant quite get my head around it!
<tbody>
</tbody>
ItemNumber | RetailPrice | Source | Price | Title |
SKU1 | 11.45 | SOURCE1 | 17.57 | Title1 |
SKU1 | 11.45 | SOURCE2 | 15.95 | Title2 |
SKU1 | 11.45 | SOURCE2 | 15.95 | Title3 |
SKU1 | 11.45 | SOURCE3 | 9.54 | Title4 |
SKU1 | 11.45 | SOURCE4 | 9.31 | Title5 |
SKU2 | 36.95 | SOURCE1 | 40.06 | Title6 |
SKU2 | 36.95 | SOURCE2 | 33.95 | Title7 |
SKU2 | 36.95 | SOURCE2 | 33.95 | Title8 |
SKU2 | 36.95 | SOURCE3 | 29.89 | Title9 |
SKU2 | 36.95 | SOURCE4 | 30.17 | Title10 |
<colgroup><col span="5"></colgroup><tbody>
</tbody>
How would i return Title 4 from SKU1 and Source2?
this is in a worksheet called "data"
this is what i have tried so far but cant quite get my head around it!
Code:
=INDEX(data!A2:G11,MATCH(A2,A2:A11,0),MATCH(FIND("SOURCE3",data!D:D,1),D2:D11,0))
<tbody>
</tbody>
Last edited: