Forum Discussion

Roberto_Cesar_Morini's avatar
Roberto_Cesar_Morini
Copper Contributor
Jan 25, 2023

Insert data from an Excel column into the same column of another spreadsheet

I need to insert into an Excel spreadsheet (which I'll call "integrative") the data coming from other spreadsheets, whose data may be in different column positions. I don't want to do it manually, i....
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 25, 2023

Roberto_Cesar_Morini 

=INDIRECT(ADDRESS(ROW(),MATCH(C$1,'another spreadsheet'!$1:$1,0),,,"another spreadsheet"))

Maybe with this formula. In the example the formula is copied down and to the right in order to add data from the "address" column into the 'integrative' sheet.

 

Resources