Changing values

  • Thread starter Thread starter Becca
  • Start date Start date
B

Becca

We are in the process of changing our accounting
software. I have two columns, one with the old account
number and one with the new, corresponding number. I
have downloaded the information from our existing
software into Excel, but would like a faster way to
change the old numbers to the new numbers other than the
Control+H trick of entering each old number and its new
number. Are there any functions that will do this?

Thanks so much!
 
Hi
one way: use VLOOKUP. e.g.
- Your old account data is stored in sheet1. Column A contains the old
account number
- Your have a mapping sheet as described below (lets say calles
'mapping_sheet'). With column A=old number; column B = new number

Try the following (after making a backup copy of your sheet)
- Insert a helper column B in your first sheet. This will store the new
account number
- In B1 enter the following formula:
=VLOOKUP(A1,'mapping_sheet'!$A$1:$B$10000,2,0)
copy this down
- To replace the formulas with values use 'Paste Special - Values'

HTH
Frank
P.S.: I'm just wondering that you use Excel to migrate from one
application to a new one - Wouldn't be my application of choice :-)
 
Thanks for the help. I will try it shortly.

As to the migration, it is from a standard accounting
software (MAS90) to a special package designed for
hospitality and and private clubs (Jonas). Jonas sales
promised a lot, but it is a pretty cheesy application.
Not very heavy on the accounting side. We mostly went
with it because we needed a POS. Hard to believe we
couldn't find something better.

Anyway,I just downloaded the basic tables (vendors,
customers, accounts, budget, etc.)

Thanks again for the help!
 
Back
Top