Dear All,
I could like to use INDEX MATCH function to obtain a specific data that i need from Raw Data. How can i implement the formula?
Please refer to example below.
Thank you all.
Raw Data (Sheet 1):-
<colgroup><col span="3"></colgroup><tbody>
</tbody>
Formula Function to be applied (Sheet 2):-
<colgroup><col span="3"></colgroup><tbody>
</tbody>
I could like to use INDEX MATCH function to obtain a specific data that i need from Raw Data. How can i implement the formula?
Please refer to example below.
Thank you all.
Raw Data (Sheet 1):-
Master Account# | Buyer Account | Seller Account |
1ABCDG | ABCD | ABCD |
1EFGHG | EFGH | EFGH |
1IJKLG | IJKL | IJKL |
1MNOPG | MNOP-L | MNOP-S |
<colgroup><col span="3"></colgroup><tbody>
</tbody>
Formula Function to be applied (Sheet 2):-
<colgroup><col span="3"></colgroup><tbody> </tbody> |
<colgroup><col span="3"></colgroup><tbody>
</tbody>