Need to add information from one spreadsheet to another using a common key field
Posted on 2011-09-27
We have a MS spreadsheet table (Table 1) with 12 columns of information. An important piece of information is located on another spreadsheet table (Table 2). Both tables have a common field (Award Number). The Award Amount information needs to be placed into Table 2.
I think that I should add a column to Table 1 with the same name as in table two. I don't know how, but I believe that a command or procedure can be made to compare the two tables using the common field and then copy the Award Amount into Table 1 when a match of the Award number is found. If necessary, Table 2 can be made to have only two columns (Award Number and Award Amount).
Any assistance that you can give will be appreciated.