Combine 2 Columns from 2 different sheets with helper

[Sekars]

Hello Friends

If the cells C4:C43 have 1 then the corresponding value in the cells B4:B43 need to be plotted in the light yellow cells E4:E40 by formulas.

thanks in advance

[samba_ravi]

E4=iferror(index($b:$b,small(index(($c$4:$c$43<>1)*10^10+row($c$4:$c$43),0),rows(e$4:e4))),"")
try this and copy towards down

[Tony Valko]

This array formula** entered in E4:

=IFERROR(INDEX(B:B,SMALL(IF(C$4:C$43=1,ROW(C$4:C$43)),ROWS(E$4:E4))),"")

** 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.

Copy down until you get blanks.

[Sekars]

Hello Siva and Biff

Thanks & thanks you formula working well and helped me lot.

thanks again

[Tony Valko]

You're welcome. Thanks for the feedback!