I want to write a macro that match multiple column and return a value as I show in the table below</SPAN> | |||
Plant </SPAN> | SLOC</SPAN> | Grade</SPAN> | Posting Date</SPAN> |
1</SPAN> | 555</SPAN> | abc</SPAN> | |
3</SPAN> | 777</SPAN> | def</SPAN> | |
2</SPAN> | 666</SPAN> | jkl</SPAN> | |
5</SPAN> | 999</SPAN> | asd</SPAN> | |
-------- | ------- | -------- | ------------ |
Material </SPAN> | Plant</SPAN> | SLOC</SPAN> | Posting Date</SPAN> |
asd</SPAN> | 5</SPAN> | 999</SPAN> | 5/5/2013</SPAN> |
jkl</SPAN> | 2</SPAN> | 666</SPAN> | 2/2/2013</SPAN> |
def</SPAN> | 3</SPAN> | 777</SPAN> | 3/3/2013</SPAN> |
abc</SPAN> | 1</SPAN> | 555</SPAN> | 1/1/2013</SPAN> |
I have to check multiple column from 2sources and get the Posting Date from Table2 to Table1. I'm quite confused about the function which I should use like match, lookup, index, etc. Can you show how can I solve this problem. Thank you</SPAN> |
<TBODY>
</TBODY>