How to give values from two reference from different sheet of excel---help

[salman_msssb]

Table1table2
Hi,

I wanna give value of @qty from table1(pic attached) from two referene <1. Invoice # & 2. Code> to Table2(pic attached) in differenct of code like RT CB, DT Jar,...

Please help me on this.

[salman_msssb]

I am facing the problem to collect the data from other sheet in workbook of two refrence one is invoice number and second is code in invoice details.

in invoice details all data feed and second is sales to collect data formully to different code... as per attached