if sheet1 columnB has matching value to sheet2 cellA(1) then copy sheet1 matched cellB to sheet2 cellH2. cycle for every cell

[aqualina]

Hello! Sounds complicated. But I hope someone can help me. I have never worked with macros function,
and can't understand how to make it work to save myself.

So i have these two sheets.

This is Sheet1

Name	Comment (empty for now)
C1
C4
R71

This is Sheet2

Number	Price	Comment
C1,C2,C4,C8	15	1-12-18
L3	22	22-14-7
R5,R15,R71	17	11-11-8

And I need VBA to compare Name, cell by cell, find matches in Number and then insert Comment in Sheet1, if match found. Like this.

Name	Comment
C1	1-12-18
C4	1-12-18
R71	11-11-8

And sorry, English is my second language.

 

[DanteAmor]

Hi and welcome to MrExcel

Try the following formula on sheet1:

Dante Amor
	A	B
1	Name	Comment
2	C1	1-12-18
3	C4	1-12-18
4	R71	11-11-8
Sheet1

Cell Formulas
Range	Formula
B2:B4	B2	=VLOOKUP("*"&A2&"*",Sheet2!A:C,3,0)

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------