Extracting data from two columns based on criteria

bossblue1994

New Member
Joined
Aug 13, 2018
Messages
2
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!

CodeNameWrapped patioEnd UnitHardwood FloorPool ViewVaulted CeilingsMarina ViewBayviewCity ViewDrumminPatioDock View
001-STEN 001-STENDrummin-End UnitHard Wood FloorPool ViewVaulted Ceilings----Patio-
001-STENEnd Unit
001-STENHardwood Floor
001-STENPatio
001-STENPool View
001-STENRent
001-STENVaulted Ceilings
001-CAM 001-CAMEnd Unit-----------
001-CAMHardwood Floor
001-CAMNo Wine Fridge
001-CAMPatio
001-CAMRent
001-STONE 001-STONEEnd Unit-----------
001-STONEHardwood Floor
001-STONEMarina View
001-STONERent
001-STONEWrapped Patio

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,109,009
Messages
5,526,258
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top