Add an if statement to an array function

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Add an if statement to an array function

Post by BittenApple »

Hello team,

I have a function as below:
=INDEX($B$2:$B$11, SMALL(IF( E3=$A$2:$A$11, ROW($A$2:$A$11)- ROW($A$2)+1), ROW(1:1)))

I want to add if statement to say:

if( c1=1, INDEX($B$2:$B$11, SMALL(IF( E3=$A$2:$A$11, ROW($A$2:$A$11)- ROW($A$2)+1), ROW(1:1))),....

Is this doable?

Regards,

Toranaga
3StarLounger
Posts: 254
Joined: 15 Aug 2016, 11:23

Re: Add an if statement to an array function

Post by Toranaga »

Hi,

It depends on what you want to do.
Have you tried the formula?
If you attach a file, we can see if the formula is good or not.