Index Match with multiple criteria and NO dup

[broth]

I have data in Column B that if is >"" = Text in Column A. I need to copy and drag this formula down in Column C showing NO spaces.

Column A	Column B	Column C
Blue	3	Blue
White	7	White
Red		Black
Black	3	Yellow
Green
Yellow	9

<tbody>
</tbody>

 

[Special-K99]

in C1
=IFERROR(INDEX($A$1:$A$100,SMALL(IF(B$1:B$100<>"",ROW($A$1:$A$100)),ROW(A1)),1),"")
Array formula, use Ctrl-Shift-Enter
and copy down the column

If you want the column B values in column D then

in D1
=IFERROR(INDEX($B$1:$B$100,SMALL(IF(B$1:B$100<>"",ROW($A$1:$A$100)),ROW(A1)),1),"")
Array formula, use Ctrl-Shift-Enter
and copy down the column

 

[broth]

Thanks this works well. Assume though that I had multiple criteria and that I only wanted text in Column A to be listed in Column D if data in both Column B & C were present.

Column A	Column B	Column C	Column D
Blue	3	2	BLue
White	7	4	White
Red			Yellow
Black	3
Green
Yellow	9	1

<tbody>
</tbody>