Look up value and return description in drop down list

Given a list of pipe sizes on column A and pipe description on column B, and cost on column C how do you return the description of the pipe when you enter the pipe size?
Also, there are multiple pipe description among the pipe sizes (for exampe, pipe size 1/2” has 15 different description).
I want to be able to enter the pipe size, then a drop down list gives me the 15 different description available for that specific size. Finally, once I choose the description, column C displays the price.

Leave a Reply

Your email address will not be published. Required fields are marked *