INDEX + MATCH Part Text of range values

[hro5e]

I have a range of name values in SHEET 1, COLUMNS A&B:

Sheet 1	A	B
1	DEL01	CV
2	DEL02	CV
3	DEL03	SS
4	DEL04	CV
5	DLM101	FD

<tbody>
</tbody>

I have a second range of description values in SHEET 2,COLUMN C:

SHEET 2	A	B	C
1			DEL02.START
2			DEL02.STOP
3			DEL02.PUSH
4			DEL02.PULL
5			DLM101.START

<tbody>
</tbody>

How can I in SHEET 2 COLUMNS A&B, INDEX SHEET 1 COLUMNs A&B and INDEX SHEET 2 COLUMN C and MATCH part of the value and insert COLUMN A's values into COLUMN B that *part match* COLUMN C.

Giving the final results:

SHEET 2	A	B	C
1	DEL02	CV	DEL02.START
2	DEL02	CV	DEL02.STOP
3	DEL02	CV	DEL02.PUSH
4	DEL02	CV	DEL02.PULL
5	DLM101	FD	DLM101.START

<tbody>
</tbody>

As you can see columns A & B have been automatically filled in because part of column C value matches values in SHEET 1 column A.

Any help would be great.

 

[alansidman]

Results:

Data Range

	A​	B​	C​	D​
1​	SHEET 2​	A​	B​	C​
2​	1​	=LEFT(D2,FIND(".",D2)-1)​	=VLOOKUP(Sheet2!B2,Sheet1!$B$2:$C$6,2,FALSE)​	DEL02.START​
3​	2​	=LEFT(D3,FIND(".",D3)-1)​	=VLOOKUP(Sheet2!B3,Sheet1!$B$2:$C$6,2,FALSE)​	DEL02.STOP​
4​	3​	=LEFT(D4,FIND(".",D4)-1)​	=VLOOKUP(Sheet2!B4,Sheet1!$B$2:$C$6,2,FALSE)​	DEL02.PUSH​
5​	4​	=LEFT(D5,FIND(".",D5)-1)​	=VLOOKUP(Sheet2!B5,Sheet1!$B$2:$C$6,2,FALSE)​	DEL02.PULL​
6​	5​	=LEFT(D6,FIND(".",D6)-1)​	=VLOOKUP(Sheet2!B6,Sheet1!$B$2:$C$6,2,FALSE)​	DLM101.START​

 

[hro5e]

Thanks for posting,

Although the descriptive data in Column C is not always structured the same.

It can vary for example:

DEL02.START
MISCHECK_NO FOR DEL02
BAGCOUNT:DEL02
DEL02_CC
DEL02-Counting

So I can't use your suggested formula (LEFT of ".")

Any ideas.