I think what I need to do is fairly simple, but am struggling to find the correct formula.

In the attached workbook, I have a sheet called "Inventory" that stores a part description and the inventory level for that part.
In the "Orders" worksheet, I want the inventory level for the particular part selected in that row to automatically fill in to column B in "Orders". In other words, I want column B to fill in the appropriate inventory value from the "Inventory" sheet, for that particular part.

Simplified workbook is attached. Thank you!!formula test.xlsx