Multiple Value Index Function Help

[mtskv5]

Hi everyone and good afternoon. I am working on an Excel sheet and I am needing a little bit of help on a formula that I am using. Here is the formula:

{=IF(ISERROR(INDEX(Month!$A$7:$C$23,SMALL(IF(Month!$A$7:$A$23=$B$4,ROW(Month!$A$7:$A$23)),ROW(1:1)),3)),"",INDEX(Month!$A$7:$C$23,SMALL(IF(Month!$A$7:$A$23=$B$4,ROW(Month!$A$7:$A$23)),ROW(1:1)),3))}

I'm not sure the problem that I am having, but this will not return to correct values. I am thinking this is a more complex issue than what I can explain on here without providing the workbook. If anyone thinks that they can lend a hand, please let me know and I will email you the workbook.

Thanks,

mtskv5

 

[Yahya]

try if this will help

=IF(ISERROR(INDEX(Month!$A$7:$C$23,SMALL(IF(Month!$A$7:$A$23=$B$4,ROW(Month!$A$7:$A$23)-ROW(Month!$A$7)+1),ROW(1:1)),3)),"",INDEX(Month!$A$7:$C$23,SMALL(IF(Month!$A$7:$A$23=$B$4,ROW(Month!$A$7:$A$23)-ROW(Month!$A$7)+1),ROW(1:1)),3))

 

[Peter_SSs]

If anyone thinks that they can lend a hand, please let me know and I will email you the workbook.

We would prefer to avoid that. Refer to #7 of the Forum Rules and 18 & 19 of the Posting Guidelines.

Most problems can be successfully solved in the public arena by a good description of what you have and what you are trying to achieve. Small screen shots can also be provided directly in the forum to assist your description. My signature block has further information about that.

 

[mtskv5]

Thank you -- you are a God send. It worked.

 

[Yahya]

Thank you -- you are a God send. It worked.

you are welcome
but please read what peter wrote

 

[T. Valko]

Hi everyone and good afternoon. I am working on an Excel sheet and I am needing a little bit of help on a formula that I am using. Here is the formula:

{=IF(ISERROR(INDEX(Month!$A$7:$C$23,SMALL(IF(Month!$A$7:$A$23=$B$4,ROW(Month!$A$7:$A$23)),ROW(1:1)),3)),"",INDEX(Month!$A$7:$C$23,SMALL(IF(Month!$A$7:$A$23=$B$4,ROW(Month!$A$7:$A$23)),ROW(1:1)),3))}

I'm not sure the problem that I am having, but this will not return to correct values. I am thinking this is a more complex issue than what I can explain on here without providing the workbook. If anyone thinks that they can lend a hand, please let me know and I will email you the workbook.

Thanks,

mtskv5

Try this...

Array entered**:

=IF(ROWS(A$1:A1)>COUNTIF(Month!$A$7:$A$23,$B$4),"",INDEX(Month!$C$7:$C$23,SMALL(IF(Month!$A$7:$A$23=$B$4,ROW(Month!$A$7:$A$23)),ROWS(A$1:A1))))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.