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


Referencing column headers as a list in another column

Posted on 2012-08-14
Medium Priority
Last Modified: 2012-08-14
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.
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


regards, barry

Author Closing Comment

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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question