returning a different cell value

  • Thread starter Thread starter Reza
  • Start date Start date
R

Reza

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
 
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))
 
Back
Top