If false then check next row (No blanks in list) formula

Probably it is possible but you need to create new thread with description about your new problem

in new thread in the first post:

Attach a sample workbook. (Not a picture!)
Make sure there is just enough data to demonstrate your need. Include a BEFORE (original) sheet and an AFTER (required output) sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary. Remember, it should reflect original structure of your data.
Remember to desensitize the data.
Note:

• Please do not attach password protected workbooks/worksheets
• Please do not attach file(s) from exterior servers
• Please do not attach file(s) with enabled any Workbook Open/Autorun macros!

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Originally Posted by WanderingMike

is this possible to do with multiple columns at once? For example if I have lists in A B C D and I want to make column E show a list.

Like this?

Data Range

	A	B	C	D	E
1	Chair	Yes	Box	Yes	Couch
2	Couch	No	Broom	Yes	Table
3	Table	No	Mop	Yes	Shelf
4	Desk	Yes	Bucket	No	Bucket
5	Lamp	Yes	Clock	No	Clock
6	Shelf	No

This array formula** entered in E1:

=IFERROR(INDEX(A:A,SMALL(IF(B$1:B$6="No",ROW(B$1:B$6)),ROWS(E$1:E1))),IFERROR(INDEX(C:C,SMALL(IF(D$1:D$6="No",ROW(D$1:D$6)),ROWS(E$1:E1)-COUNTIF(B$1:B$6,"No"))),""))

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

You're welcome. Thanks for the feedback!