Looking for a lookup formula

[Brusky]

Hi, I'm trying to match actual orders to budgeted orders.

Column A: Part number
Column B: Actual Order Qty

Column C: Display Part Number Most of should be the same as part number in column A, but not all of them map.
Column D: Budgeted Order Qty

I would like to add a column to show for Column C the qty from Column B where applicable for the same part number.

Any suggestion?

 

[kweaver]

Would you provide a few examples?

 

[Brusky]

Here is the example.

https://www.dropbox.com/s/xxf1a8rz4817mrf/lookup.xlsx?dl=0


i just want it so that column E will return from column B the corresponding qty for the mapped part numbers from column C. Where there are no actual orders there would be some kind of error or value missing, etc. I'm guessing its a basic formula that i havent yet been able to figure out.

 

[Peter_SSs]

Is this what you mean?

Excel 2016
	A	B	C	D	E
1	Part Number	Actual Order Qty	Display Part Number	Forecast Qty	Actual Order Qty from Column B
2	AAAA	5	IIIII	250	29
3	BBBB	14	JJJJJ	150	1
4	CCCC	20	AAAA	200	5
5	DDDD	1	GGGG	100	8
6	EEEEE	0	ZZZZ	220	#N/A
7	FFFFF	32	BBBB	80	14
8	GGGG	8	CCCC	400	20
9	HHHH	12	DDDD	75	1
10	IIIII	29	QQQQ	400	#N/A
11	JJJJJ	1	FFFFF	400	32
12			RRRR	150	#N/A
13			MMMM	100	#N/A
14			OOOO	300	#N/A
15			XXXX	90	#N/A
Sheet1

Cell Formulas
Range	Formula
E2	=VLOOKUP(C2,A$2:B$11,2,0)

 

[Brusky]

exactly. thanks!!

 

[Peter_SSs]

exactly. thanks!!

You're welcome.