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

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
.

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
.