Hello there!

I have 2 lists. One list of products and another list with the prices for said products.

I want excel to auto complete the price for the product selected from a drop down list, to another cell nearby. I have already made a drop down list to select the product but cannot really figure what I need to do to next!

Please help!