Extracting data from two columns based on criteria

[bossblue1994]

Hi there,
I am looking for a formula that searches through the bold column and returns a corresponding value (I.e Drummin, End Unit, Hardwood Floor etc.) on one single row. This is a sample size of a larger spread sheet and I need the formula to run through the entire document and automatically populate. My hunch is that its an index match but I can't seem to figure it out. The first set of data (001-STEN) is an example of how I need this to look. 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

Hard Wood Floor

Pool View

Vaulted Ceilings

-

-

-

-

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

<tbody>
</tbody>