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,
Add an if statement to an array function
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
-
- 3StarLounger
- Posts: 254
- Joined: 15 Aug 2016, 11:23
Re: Add an if statement to an array function
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.
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.