Populate cells based on drop downs and quantity

[avozella]

Hi everyone,

First time poster here and I have limited excel experience. After scouring dozens of youtube videos i cant find what im looking for.

I am trying to create an easy way to populate cells based on 2 drop down selection and quantities.

In the example I uploaded I would like the 'Product' drop down and
Term' drop down combined with the Quantity to populate the Part, Detail, and MSRP fields.

I have a few hundred lines of products i want to be able to quick look up. Once I have an idea of how to do it I can probably expand it to encompass all.

Thank you for any help or guidance.