Convert a old chart of accounts to a new one

[virsanpal]

OLD NEW Account Description Account Description 042101002 House Fund - General Cashier 1000 HOUSE FUNDS 042101003 House Fund - Human Resources 1010 BANK REVENUE ACCOUNT 042101004 House Fund - Materials Manager 1011 BANK EXPENSE ACCOUNT 042101006 House Fund - Outlet Cashiers 1012 BANK ACCOUNT ALCOHOL 042101007 House Fund - Front Office Depa 1020 BANK ACCOUNT TERM DEPOSIT 042102001 Bank Account 1 - Expense 1070 VISA CREDIT CARD 042102002 Bank Account 2 - Collection 1071 MASTER CREDIT CARD 042102003 Bank Account 3 - Alcohol 1072 AMEX CREDIT CARD 042104001 Guest Ledger 1073 DINERS CREDIT CARD 042104002 City Ledger 1074 JCB CREDIT CARD 042104004 AR Employee Loan 1080 CHECKS UNDER COLLECTION 042104005 AR Employee Advances 1081 PETTY CASH 042104007 AR Insurance Claims 1085 NOTE RECEIVABLE 042104009 AR Overpayment, Leave Settlement 1090 CASH SALES CLEARANCE 042104010 AR Travel Advance 1091 CITY LEDGER CLEARANCE 042104011 AR Visa Advance 1092 CREDIT CARD CLEARANCE 042104020 VAT - Input Tax 5% 1093 GENERAL CASHIER CLEARANCE 042104090 AR Others 1094 TIPS CLEARANCE 042104099 Provision for Bad & Doubtful Debt 1095 FOREIGN EXCHANGE CLEARANCE 042106001 Food Main Store 1096 PACKAGE LEDGER CLEARANCE 042106002 ******* Food Stock 1100 RECEIVABLES (CITY LEDGER) 042106005 Beverage Main Store 1101 RECEIVABLES (GUEST LEDGER) 042106006 Outlet Beverage Stock 1105 RECEIVABLE VACATION / FINAL SETTLEMENT 042106007 Tobacco 1110 RECEIVABLE INTEREST 042106009 Outlet Merchandise Stock 1113 TRAVEL ADVANCES 042106010 General Stores 1114 SALARY ADVANCES 042106020 Engineering Stores 1115 SUPPLIER ADVANCES <colgroup><col><col><col><col><col></colgroup><tbody> </tbody> <strike></strike>

<tbody>
</tbody>

Good Morning,
I need to convert the old chart of accounts to a new one with different numbers and names. Although the names are similar, for example receivables (City Ledger) corresponds tp City ledger on the old one. So I want to match it and once it finds similar wording change the account number.
I tried vlookup and search but is not working.
Could you help me on this. Thanks in advance Virginia

 

[Michael M]

Looking at bot tables, they don't really have much in common.....I'm guessing you will be honing your typing skills for this one !!

 

[virsanpal]

I know that is how they gave it to me so dont really know what to do.