Extracting data from two columns onto one single row

[bossblue1994]

Hi,

I am looking for a formula that automatically searches through the bold columns and returns each of the matched values that I need. The first set of data 001-STEN is how I need the formula to operate. My hunch is that its some iteration of an index match formual but I have not been able to figure it out. Thanks in advance, this would be a huge help!

Code

Name

Wrapped patio

End Unit

Hardwood Floor

Pool View

Vaulted Ceilings

Marina View

Bayview

City View

Drummin

Patio

Dock View

001-STEN

001-STEN

Drummin

-

End Unit

Hardwood Floor

Pool View

Vaulted Ceilings

-

-

-

Drumin

Patio

-

001-STEN

End Unit

001-STEN

Hardwood Floor

001-STEN

Patio

001-STEN

Pool View

001-STEN

Rent

001-STEN

Vaulted Ceilings

001-CAM

001-CAM

End Unit

-

-

-

-

-

-

-

-

-

-

-

001-CAM

Hardwood Floor

001-CAM

No Wine Fridge

001-CAM

Patio

001-CAM

Rent

001-STONE

001-STONE

End Unit

-

-

-

-

-

-

-

-

-

-

-

001-STONE

Hardwood Floor

001-STONE

Marina View

001-STONE

Rent

001-STONE

Wrapped Patio

<colgroup><col><col><col><col><col><col><col><col span="4"><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...tracting-data-two-columns-based-criteria.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.