Consider I have 2 tables which are in same sheet.
Table 1: Sales and Table 2: Production
In Sales table I need to calculate the profit column. Its data will be picked from Production cost table based on the Type and Size from Sales table.
Suppose I have sold 5000 ml 1 qty Groundnut so first it should search for the production cost for 5000ml ground nut in production table. In the current example if I sold 5000ml qty of groundnut then it manufacturing cost should pe extract in the column so that I can subtract it from my sales price.
Production Cost Table :
Sales Table :
