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

[iMailMan]

Data Table: [TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Item Code[/TD]
[TD="align: center"]Qty[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]123
[/TD]
[TD="align: center"]1000[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]456[/TD]
[TD="align: center"]700[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]789[/TD]
[TD="align: center"]2000[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]123[/TD]
[TD="align: center"]500[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]456[/TD]
[TD="align: center"]1200[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]789[/TD]
[TD="align: center"]3500[/TD]
[/TR]
</tbody>[/TABLE]


Table for data entry: [TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]Qty[/TD]
[TD="align: center"]Qty[/TD]
[/TR]
[TR]
[TD="align: center"]Item Code[/TD]
[TD="align: center"]Location A[/TD]
[TD="align: center"]Location B[/TD]
[/TR]
[TR]
[TD="align: center"]123[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]456[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]789[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.