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!



[TABLE="width: 1292"]
<colgroup><col><col><col><col><col><col><col><col span="4"><col><col><col></colgroup><tbody>[TR]
[TD]Code[/TD]
[TD] [/TD]
[TD]Name[/TD]
[TD]Wrapped patio[/TD]
[TD]End Unit [/TD]
[TD]Hardwood Floor[/TD]
[TD]Pool View[/TD]
[TD]Vaulted Ceilings[/TD]
[TD]Marina View[/TD]
[TD]Bayview[/TD]
[TD]City View[/TD]
[TD]Drummin[/TD]
[TD]Patio[/TD]
[TD]Dock View[/TD]
[/TR]
[TR]
[TD] 001-STEN[/TD]
[TD] 001-STEN[/TD]
[TD]Drummin[/TD]
[TD]-[/TD]
[TD]End Unit [/TD]
[TD]Hardwood Floor[/TD]
[TD]Pool View[/TD]
[TD]Vaulted Ceilings[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Drumin[/TD]
[TD]Patio[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STEN[/TD]
[TD]End Unit[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STEN[/TD]
[TD="colspan: 2"]Hardwood Floor[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STEN[/TD]
[TD]Patio[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STEN[/TD]
[TD]Pool View[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STEN[/TD]
[TD]Rent[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STEN[/TD]
[TD="colspan: 2"]Vaulted Ceilings[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 001-CAM[/TD]
[TD] 001-CAM[/TD]
[TD]End Unit[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-CAM[/TD]
[TD="colspan: 2"]Hardwood Floor[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-CAM[/TD]
[TD="colspan: 2"]No Wine Fridge[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-CAM[/TD]
[TD]Patio[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-CAM[/TD]
[TD]Rent[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 001-STONE[/TD]
[TD] 001-STONE[/TD]
[TD] End Unit[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STONE[/TD]
[TD="colspan: 2"] Hardwood Floor[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STONE[/TD]
[TD] Marina View[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STONE[/TD]
[TD] Rent[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] 001-STONE [/TD]
[TD="colspan: 2"]Wrapped Patio[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

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