Thread: Need a formula (possibly something like VLOOKUP) that will return multiple results.
View Single Post
 
Old 08-10-2016, 12:53 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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.
Reply With Quote