returning a different cell value
 

heya,

based on a condition, i want the return value to be the value at the top of
the column.
for example,

i want to find the largest and 2nd largest values in a row =LARGE(B4:Q4,1)
& =LARGE(B4:Q4,2), but i want there return values to be the text in their
respective columns. so if B4 was the largest i want the return value to be
text in B1 (column header)

Thank you person who is smarter than me :), thanks

returning a different cell value
 

Try it like this:

=INDEX(B1:Q1,MATCH(LARGE(B4:Q4,1),B4:Q4,0))

=INDEX(B1:Q1,MATCH(LARGE(B4:Q4,2),B4:Q4,0))

--
Biff
Microsoft Excel MVP


"Reza" wrote in message
...
heya,

based on a condition, i want the return value to be the value at the top
of
the column.
for example,

i want to find the largest and 2nd largest values in a row
=LARGE(B4:Q4,1)
& =LARGE(B4:Q4,2), but i want there return values to be the text in their
respective columns. so if B4 was the largest i want the return value to be
text in B1 (column header)

Thank you person who is smarter than me :), thanks