Excel Lookup help where rows contain multiple values

[LEEDELALB]

Hello, I have the following data in two sheets


Sheet 1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Type
[/TD]
[TD]Old Date
[/TD]
[TD]New Date
[/TD]
[/TR]
[TR]
[TD]REFGT LKMNOP
[/TD]
[TD]1/13/2016
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]
[TABLE="width: 113"]
<tbody>[TR]
[TD]Type
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 80"]
<tbody>[TR]
[TD]Correct Date
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 113"]
<tbody>[TR]
[TD]REFGT
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 80"]
<tbody>[TR]
[TD="align: right"]1/13/2016
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 113"]
<tbody>[TR]
[TD]LKMNOP
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 80"]
<tbody>[TR]
[TD="align: right"]1/15/2016
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

I need to populate the New Date field in sheet one with both dates from Sheet 2 using a ";" as a delimiter. Is there a way to do this in Excel where it can match part of the information in a row?

 

[Gerald Higgins]

Hi, welcome to the board.

Can we just be clear, what exactly do you want to show in the New Date field in Sheet 1 ?

Is it something like this -

1/13/2016 ; 1/15/2016

?

 

[Gerald Higgins]

Sorry, another question.

I'm guessing a key part of this is, how do we split the "TYPE" into two parts ?
Are they fixed length ?
Or maybe we split them at the space character, and this is do-able because there is only ever one space character ?

 

[LEEDELALB]

Hi,

Yes.. That is the correct thread.

 

[LEEDELALB]

Hi The example I gave is just a simple one. Some rows might have 20/50/100 parts inside of them and every part is a different length and variation of number, characters and letters.

 

[Gerald Higgins]

Re post #5 - OK, so how do know which bit to cross reference ?

 

[LEEDELALB]

I would like to use the values in sheet 2 column "Type" to identify those strings in the sheet 1 column "type". Sheet 2 has all of the values broken out into their own rows with their correct dates.