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

[iMailMan]

Here is the table of the data for your reference:
[TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
[TD="align: center"]Location[/TD]
[TD="align: center"]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]


Here is the table for data entry:
[TABLE="class: grid, width: 300, 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][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have try many formula like Vlookup+Hlookup or Index+Match or Vlookup+Match still not successful to get the data entry on the above table mentioned.
Please help and educate me.


Thanks.

 

[Peter_SSs]

Glad you got a useful solution. Thanks for letting us know.