How can I copy a column from one sheet to another sheet based on title in Excel?
Solution 1:
=HLOOKUP(A$1,Sheet1!$A:$C,ROW(),FALSE)
As you fill the formula down, the ROW() acts as an offset to look at the next column on your table.
How can I copy a column from one sheet to another sheet based on title in Excel?
Solution 1:
=HLOOKUP(A$1,Sheet1!$A:$C,ROW(),FALSE)
As you fill the formula down, the ROW() acts as an offset to look at the next column on your table.