UPVC Inventory Excel Formulas

I already keep my UPVC store stock in Excel, but the sheet is little more than a long table. I now need it to do the thinking for me. Specifically, I want formulas—at an intermediate level—to pull in correct... (Budget: ₹400 - ₹750 INR, Jobs: Data Analysis, Data Management, Data Visualization, Excel, Excel VBA, JavaScript, Visual Basic)