Consolidating Data with three Columns

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,686
Office Version
  1. 2019
Platform
  1. Windows
I have four spreadsheets that I want to consolidate into a sperate workfile. There are three columns

1) Account Number
2) Decription
3) Amount

I want all three to appear on the consolidated report. At present I can only get the account number and the amount to appear on the consolidated workfile.

How can I can the descriptions to appear as well.

Howard
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,118,710
Messages
5,573,743
Members
412,550
Latest member
soking
Top