goodmachine
Board Regular
- Joined
- Oct 7, 2009
- Messages
- 70
Problem: I have a spreadsheet that contains UNSPSC codes or commodity codes that are mapped to GL Accounts. I need to update the UNSPSC codes to the new GL accounts from an updated sheet provided from finance.
1) First thing I need to do is add the text "SHARE" as a prefix in front of the UNSPSC codes on the sheet provided from finance- how can I do that?
For example: 123456, needs to appear as SHARE:123456
Once I complete, I can begin work on updating the GL Accounts on the spreadsheet that I own.
2) Column A in the finance sheet contains the newly updated UNSPC codes that now have the "SHARE" in front of the UNSPSC codes.
Column G in the finance sheet contains the new GL Accounts.
I need to update the GL Accounts in Column A in the sheet I own from the values in Column G on the Finance Sheet.
For example: I need to update the 677010 in My Sheet to 699080 based on the Commodity Code
Finance Sheet
<tbody>
</tbody>
My Sheet
<tbody>
</tbody>
The data that ties these two separate sheets are the UNSPSC codes. I'm assuming this would have to be done with VLOOKUP, but my skills are not that great. Also, I am using Excel 2007.
Any help would be greatly appreciated.
Thanks!
1) First thing I need to do is add the text "SHARE" as a prefix in front of the UNSPSC codes on the sheet provided from finance- how can I do that?
For example: 123456, needs to appear as SHARE:123456
Once I complete, I can begin work on updating the GL Accounts on the spreadsheet that I own.
2) Column A in the finance sheet contains the newly updated UNSPC codes that now have the "SHARE" in front of the UNSPSC codes.
Column G in the finance sheet contains the new GL Accounts.
I need to update the GL Accounts in Column A in the sheet I own from the values in Column G on the Finance Sheet.
For example: I need to update the 677010 in My Sheet to 699080 based on the Commodity Code
Finance Sheet
Commodity Code | B | C | D | E | F | New Account |
SHARE:4014 | 699080 |
<tbody>
</tbody>
My Sheet
Account | Common ID | |
SHARE:677010 | 4014 |
<tbody>
</tbody>
The data that ties these two separate sheets are the UNSPSC codes. I'm assuming this would have to be done with VLOOKUP, but my skills are not that great. Also, I am using Excel 2007.
Any help would be greatly appreciated.
Thanks!