Combining INDEX functions

**wilsoa** · 03-26-2012, 02:56 PM

Is there any way to combine the following?

=IFERROR(INDEX(Combined!$C$4:Combined!$C$22,SMALL(IF(Combined!$D$4:Combined!$D$22="0600-1430",ROW(Combined!$D$4:Combined!$D$22)-3),ROW()-23)),"")

and

=IFERROR(INDEX(Combined!$C$4:Combined!$C$22,SMALL(IF(Combined!$D$4:Combined!$D$22="1400-2230",ROW(Combined!$D$4:Combined!$D$22)-3),ROW()-23)),"")

Thanks in advance!

**daddylonglegs** · 03-26-2012, 03:01 PM

What do you mean "combine"? Do you want an "OR" type setup with either of those values, if so try

=IFERROR(INDEX(Combined!$C$4:$C$22,SMALL(IF((Combined!$D$4:$D$22="0600-1430")+(Combined!$D$4:$D$22="1400-2230"),ROW(Combined!$D$4:$D$22)-3),ROW()-23)),"")

**JieJenn** · 03-26-2012, 03:01 PM

Can you attach a sample file? I think I have a solution but need to see the data first.

**wilsoa** · 03-26-2012, 03:07 PM

YES!! That is exactly what I needed!

=IFERROR(INDEX(Combined!$C$4:$C$22,SMALL(IF((Combined!$D$4:$D$22="0600-1430")+(Combined!$D$4:$D$22="1400-2230"),ROW(Combined!$D$4:$D$22)-3),ROW()-23)),"")

I was trying to do a nested IF function inside the SMALL portion, and I can see now why it wouldn't work!

THANK YOU!