How to improve accounting in excel?

Question

excel

There is an Excel table in which the online store accounting table is maintained.
There are 2 tabs - Accounting, Warehouse.
Warehouse tab - Goods arrived on 08/01/20 in a quantity of 20 pieces.

Accounting tab - The product was sold for the first time on 08/08/20 in a quantity of 1 pieces.

- How to make it so that the data Purchase, Price (Retail) are pulled up from the warehouse to Accounting automatically after I select the Apple that I brought to the warehouse in the (Product name) tab?
- How to make it so that in the Warehouse tab "Sold", "Remainder", "Return" from the tab (Accounting) would be pulled up?
I would be very grateful for your help! Thank you very much!

Answer 1

Set VLOOKUP or SUMIF for the fields of interest.