Brandon McPeak February 2016

In Excel, return all values from separate sheet for columns with matching headers

I need to pull all values from columns with matching data headers from a sheet we'll call "Source" to a sheet we'll call "Destination", under the matching header.

For instance, there is a column with header "Address" in both sheets. In the Source sheet, that column contains URLs. I need a way to pull all of these URLs into the "Address" column in the Destination sheet.

I'm not sure if this will make a difference, but I need to do the same for quite a few columns in these sheets.

Is there a way to do this?

Thanks in advance!

Answers


Jerry Jeremiah February 2016

You could paste this formula in every cell on the Destination sheet that you want to pull a value for. You will need to change the forumla from $A:$Z and from $A$1:$Z$1 to something else depending on how many columns are in the source sheet:

=IF(ISBLANK(INDEX(Source!$A:$Z,ROW(),MATCH(A$1,Source!$A$1:$Z$1,0))),"",INDEX(Source!$A:$Z,ROW(),MATCH(A$1,Source!$A$1:$Z$1,0)))

Post Status

Asked in February 2016
Viewed 3,071 times
Voted 10
Answered 1 times

Search




Leave an answer