Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Retrieve the column label based on the value of a row - Excel

Posted on 2012-09-14
Medium Priority
394 Views
I have the following table

Q1  Q2  Q3  Q4  BENEFIT_START
PROJECT 1   0     0     1    0
PROJECT 2   0     1     0    0

The number 1 indicates when the benefits start for a project. I would like to have a formula the puts the Quarter where benefits start under the column BENEFIT_START.  In the example above I would like to put Q3 next to project 1 and Q2 next to project 2
0
Question by:fitaliano
1 Comment

LVL 43

Accepted Solution

Saqib Husain, Syed earned 2000 total points
ID: 38400924
Assuming that the Qs are in row 1 enter this formula in row 2 and copy down

=index(\$B\$1:\$E\$1,match(1,B2:E2,0)

**********Edited*************
0

## Featured Post

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month12 days, left to enroll