Merge 2 XLS files into 1

Excel 2000

I need to Merge 2 .xls files into 1. How can I do that?

I tried Pivot (Microsfor Excel List or Database).. did not work....

I tried Pivot (External Data Source) with Microsoft Query and it is not installed on my comp. The guy with the CDs at work is gone for the day.

Any ideas? I need this done ASAP.

Both have 1 main column that is the same. I need to match them up and then Insert on of the columns into the other xls spreadsheet.

Thanks

Use a combination of INDEX with MATCH

INDEX(array,row_num,column_num)
returns the value of a specified cell or array of cells within array.

Use Match to find the Row_Num & Col_Num
MATCH(lookup_value,lookup_array,match_type)

Or VLOOKUP can be used if your data is sorted alphabetically.