I have two columns of data: Column A = Account Numbers, Column B= Transaction Description with Account Number
They cannot be sorted to match and they are not in any particular order.
I need to match column A to the correct description in column B, and preferably have the matching account number from column A inserted into a new column C.
Here's an example of what I have and the end result I need:
Before:
<colgroup><col><col></colgroup><tbody>
</tbody>
After:
<colgroup><col><col></colgroup><tbody>
</tbody>
I have tried different vlookups and index-match formulas with no results. Please help...!
They cannot be sorted to match and they are not in any particular order.
I need to match column A to the correct description in column B, and preferably have the matching account number from column A inserted into a new column C.
Here's an example of what I have and the end result I need:
Before:
<tbody> </tbody> | |||||||||||||||
<colgroup><col><col></colgroup><tbody>
</tbody>
After:
<tbody> </tbody> |
<colgroup><col><col></colgroup><tbody>
</tbody>
I have tried different vlookups and index-match formulas with no results. Please help...!