Excel Inventory Dependency Fix

I need help fixing an Excel spreadsheet for materials inventory. I have all the data and the first two columns working, but I need to make the price column dependent on the material type. Requirements: - Price should be pulled automatically from existing data based on material type selection from a dropdown. - Material type is defined through dropdown selection. Ideal Skills: - Proficient in Excel, especially with dropdowns and interdependent columns. - Experience with data validation and formula setup. Please ensure the price column works correctly based on my material type dropdown.

Project ID: 40409994