![]() |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
|
||||
|
||||
|
Thank you for helping
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
#2
|
|||
|
|||
|
I don't know if this can be of any use but:
=INDEX(C3:L3,N(IF(1,MATCH({1,2,3,4,5};INT(C4:L4/600);0)))) (array formula) will return an array with your wanted result. The cell will only show YR2, but try to select the cell with the formula, then press F2 and afterwards press F9. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to make MATCH/INDEX formula return multiple successive responses.
|
danigirl121 | Excel | 7 | 06-08-2016 01:57 PM |
| Excel Formula for Multiple Conditions & Results | nowco | Excel | 4 | 03-16-2016 11:24 AM |
| formula needed to sum weeknum results from multiple worksheets | JOJO101 | Excel | 0 | 06-27-2015 11:06 PM |
| Vlookup returns inconsistent results | Jhnsnkth527 | Excel | 0 | 04-16-2015 12:36 PM |
| Possibly a VLookup | mrswarrick | Excel | 3 | 01-13-2012 11:12 AM |