In excel work book one, I have account codes that look like this.
[TABLE="width: 159"]
<tbody>[TR]
[TD]00-1-110-31011[/TD]
[/TR]
[TR]
[TD]00-1-110-31031[/TD]
[/TR]
[TR]
[TD]00-1-110-31042[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 169"]
<tbody>[TR]
[TD]110-31011 Total[/TD]
[/TR]
[TR]
[TD]110-31031 Total[/TD]
[/TR]
[TR]
[TD]110-31042 Total[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 159"]
<tbody>[TR]
[TD]00-1-110-31011[/TD]
[/TR]
[TR]
[TD]00-1-110-31031[/TD]
[/TR]
[TR]
[TD]00-1-110-31042[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 169"]
<tbody>[TR]
[TD]110-31011 Total[/TD]
[/TR]
[TR]
[TD]110-31031 Total[/TD]
[/TR]
[TR]
[TD]110-31042 Total[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.