Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Return Column header, if row value is > X
I need to create a formula the looks at a row range for a value over
$1,000,000 and if a cell in the row matches the criteria, return the header of that column that matches the cell... For example A B C D 1 "What FY contains value 1,000,000?" __________ 2 FY01 FY02 FY03 FY04 3 1,500 15,000 150,000 1,500,000 DESIRED result in cell D1 should be FY04. Any solutions on how to write this formula? I'm sure it will be a nesting statement. Thanks |
#2
|
|||
|
|||
Copy this into D1:
=INDEX(2:2,MATCH(TRUE,3:31000000,0)) and then press ctrl/shift/enter. XL will automatically place {} around the formula to indicate that it's an array formula. HTH Jason Atlanta, GA -----Original Message----- I need to create a formula the looks at a row range for a value over $1,000,000 and if a cell in the row matches the criteria, return the header of that column that matches the cell... For example A B C D 1 "What FY contains value 1,000,000?" __________ 2 FY01 FY02 FY03 FY04 3 1,500 15,000 150,000 1,500,000 DESIRED result in cell D1 should be FY04. Any solutions on how to write this formula? I'm sure it will be a nesting statement. Thanks . |
#3
|
|||
|
|||
Jason, you are wonderful! Thank you it worked!
"Jason Morin" wrote: Copy this into D1: =INDEX(2:2,MATCH(TRUE,3:31000000,0)) and then press ctrl/shift/enter. XL will automatically place {} around the formula to indicate that it's an array formula. HTH Jason Atlanta, GA -----Original Message----- I need to create a formula the looks at a row range for a value over $1,000,000 and if a cell in the row matches the criteria, return the header of that column that matches the cell... For example A B C D 1 "What FY contains value 1,000,000?" __________ 2 FY01 FY02 FY03 FY04 3 1,500 15,000 150,000 1,500,000 DESIRED result in cell D1 should be FY04. Any solutions on how to write this formula? I'm sure it will be a nesting statement. Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |