In excel work book one, I have account codes that look like this.
<tbody>
</tbody>
This account code occupies one cell and is followed by a $ value in the next adjacent cell.
In excel work book two, I have account codes that look like this.
<tbody>
</tbody>This account code occupies one cell as well. and is followed by a $ value in the next adjacent cell too.
I need to match the information from excel work book 2 and transfer it into work book 1. I would normally use a SumIF function for this but the cell's information isn't an exact match between cells. Excel Workbook 2 is also set up as a subtotal which may affect the formula required as well.
Is there a variation of the SumIF formula I can use to look up the corresponding values in the 2nd workbook to populate the first workbook?
Thank you in advance.
00-1-110-31011 |
00-1-110-31031 |
00-1-110-31042 |
<tbody>
</tbody>
This account code occupies one cell and is followed by a $ value in the next adjacent cell.
In excel work book two, I have account codes that look like this.
110-31011 Total |
110-31031 Total |
110-31042 Total |
<tbody>
</tbody>
I need to match the information from excel work book 2 and transfer it into work book 1. I would normally use a SumIF function for this but the cell's information isn't an exact match between cells. Excel Workbook 2 is also set up as a subtotal which may affect the formula required as well.
Is there a variation of the SumIF formula I can use to look up the corresponding values in the 2nd workbook to populate the first workbook?
Thank you in advance.