Compare values between two columns in different sheet

[excelnoobhere]

Hello all, excel noob here and i would appreciate any help from an excpert.

I have a workbook that contains two pages. I want to be able to compare sheet1 column C to sheet2 column B then if it matches, I want to take the value in sheet 2 column D then pasted it at sheet1 column U.
for example

sheet 1

A B C D-T
11-11 222
11-13 333
11-13 444




Sheet 2
A B C D
11-11 222 descr. 3
11-12 333 descr. 5
11-13 000 descr. 6



after code sheet 1 becomes




sheet 1

A B C D-T U
11-11 222 3
11-13 333 5
11-13 444

I don't want anything deleted from sheet 1

 

[Toadstool]

Hi Excelnoobhere,

Here's Sheet2 data

Book1
	A	B	C	D
1	11-11	222	descr.	3
2	11-12	333	descr.	5
3	11-13	000	descr.	6
Sheet2

Here's Sheet1 data and the INDEX & MATCH:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	11-11	222																			3
2	11-13	333																			5
3	11-13	444
4
Sheet1

Cell Formulas
Range	Formula
U1:U4	U1	=IFERROR(INDEX(Sheet2!D:D,MATCH(Sheet1!B1,Sheet2!B:B,0)),"")

 

[DanteAmor]

Sounds like VLookup

varios 27jul2020.xlsm
	B	C																		U	V
1		222																		3
2		333																		5
3		444
4
Sheet1

Cell Formulas
Range	Formula
U1:U3	U1	=IFERROR(VLOOKUP(C1,Sheet2!B:D,3,0),"")

 

[excelnoobhere]

Hi Excelnoobhere,

Here's Sheet2 data

Book1
	A	B	C	D
1	11-11	222	descr.	3
2	11-12	333	descr.	5
3	11-13	000	descr.	6
Sheet2

Here's Sheet1 data and the INDEX & MATCH:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	11-11	222																			3
2	11-13	333																			5
3	11-13	444
4
Sheet1

Cell Formulas
Range	Formula
U1:U4	U1	=IFERROR(INDEX(Sheet2!D:D,MATCH(Sheet1!B1,Sheet2!B:B,0)),"")

this worked great thank you so much!

is there a way I can put this into a MACRO where it goes through all pages on the workbook and copies the quantity into each column starting at U (each page would have its own column that will transfer the value from D to the main page)?