I need to add data to record from a different table - Example:

Table 1 contains: Custmer, Invoice Number, Shipment Number, Product
Number, and many other details

Table contains: Custmer, Invoice Number, Product Number and some data
that are not exist in table 1 such as Amount left to be shipped

Is there a formula that I cann find the correct data that match 3
parmeters in table 1 and to bring it from table 2 to table 1 ?

hope I was clear enough'
thanks
NK