Starting Position:
My old question here serves as a basis:
I want to create a conditional list from an existing table. I have a 2D-table that contains my condition in the first column and the actual content of the list to be created (still unfiltered) in the second and third column.
This question is now to be expanded to include another requirement:
How can I create a combined list (in column E; like column F) from two separate columns (colum C + column B) in Excel 2019?
The current formula for column E is in A10.
My current status:
My current status is based on the answer to the initial question.
=IFERROR(INDEX($B$2:$B$7,AGGREGATE(15,6,(ROW($A$2:$A$7)-ROW($A$2)+1)/($A$2:$A$7<>""),ROWS(D$1:D1))),"").
>Solution :
Just Concatenate two separate INDEXes looking at the two columns:
=IFERROR(
INDEX($C$2:$C$7,AGGREGATE(15,6,(ROW($A$2:$A$7)-ROW($A$2)+1)/($A$2:$A$7<>""),ROWS(D$1:D1)))
&": "&
INDEX($B$2:$B$7,AGGREGATE(15,6,(ROW($A$2:$A$7)-ROW($A$2)+1)/($A$2:$A$7<>""),ROWS(D$1:D1)))
,"")