use of INDEX and MATCH

[alesbury]

Okay, problem 1 solved !

I now need to show that when DATA SET A goes above a value is displays that month.

I tried

=INDEX(B23:HQ23,MATCH(TRUE,B23:HQ24>50000,0))

but that comes up with N/A.

Any ideas where i am going wrong ?

Thanks in advance for your help !
Si

 

[alesbury]

I've realised that reading this may not make a lot of sense.

So to clarify.

Month 1 Month 2 Month 3 Month 4 Month 5 Month 6
303 607 910 1213 1517 1820

When the value below goes over 50 000 (or number defined by a cell) I need the cell to display the month this occurs.

I have extended the values to past 50 000 on the sheet. Is there a better way of doing this?

either way if you can help with the getting me to show the month when 50 000 is reached that would be great !!

thanks in advance
si

 

[Andrew Poulsom]

The MATCH reference should be B24:HQ24. To avoid having to confirm your array formula with Ctrl+Shift+Enter, you can use:

=INDEX(B23:HQ23,MATCH(TRUE,INDEX(B24:HQ24>50000,),0))

normally entered.

 

[alesbury]

ah !!

missed it ! thanks !