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.
Bookmarks