[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Referencing column headers as a list in another column

Posted on 2012-08-14
Medium Priority
405 Views
Is there a formula I can use to reference many column headers in order to create them as a list on another sheet, making sure the list reflects any changes the headers might undergo?

I do not want to copy/paste special/transpose and just using the = sign to go and grab the cell reference itself is a bit tedious.

Attached is a mock up that I hope will help illustrate the problem.  Please let me know if you have any questions!

Many thanks.
0
Question by:xllvr

LVL 50

Accepted Solution

barry houdini earned 2000 total points
ID: 38293613
Assuming you know that headers will start at E5 then try this formula in B9 copied down as far as might be required

=INDEX(\$E\$5:\$IV\$5,ROWS(B\$9:B9))&""

regards, barry
0

LVL 1

Author Closing Comment

ID: 38293649
Works great, Barry.  Thanks very much!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
###### Suggested Courses
Course of the Month18 days, 21 hours left to enroll