What is the formula to lookup quantity of an item code by different location sorting?

[iMailMan]

Data Table:

Location	Item Code	Qty
A	123	1000
B	456	700
A	789	2000
B	123	500
A	456	1200
B	789	3500

<tbody>
</tbody>

Table for data entry:

	Qty	Qty
Item Code	Location A	Location B
123
456
789

<tbody>
</tbody>

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1069642-what-formula-lookup-quantity-item-code-different-location-sorting.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.